ORACLE

记录一下TIPTOP
访客评论 点击获得Trackback地址
#1
回复 yaner 2015-03-25, 11:27 AM
select shb01,shb04,gen02,shb081,shb082,shb10,ima02,shb08,shb02,shb03,shb111,shb115,shb112,shc04,qce03,shc05 from shb_file,gen_file,ima_file,shc_file,qce_file,ecm_file where
shb04=gen01 and shb10=ima01 and shc04=qce01 and ecm04=shb081 and shb01=shc01 and ecm03_par=shb10 and ecm01=shb05 and
shb03>to_date('2015/01/31','YYYY/mm/dd') and shb03<to_date('2015/03/01','YYYY/mm/dd')
发表评论