| SELECT tlf01,ima02,ima021,ima08, year(tlf06) as year,month(tlf06) as month, tlf06,tlf026,tlf036,tlf10, tlf11,tlf024,tlf907,tlf13,tlf08,imk09,img10 FROM tlf_file left join ima_file on tlf01=ima01 left join img_file on tlf01=img01 and tlf902=img02 and tlf903=img03 and tlf904=img04 left join imk_file on tlf01=imk01 and tlf902=imk02 and tlf903=imk03 and tlf904=imk04 and (CASE WHEN to_char(to_date('2016-08-01','yyyy-mm-dd'),'mm')=1 THEN imk05=to_char(to_date('2016-08-01','yyyy-mm-dd'),'yyyy')-1 and imk06=12 ELSE imk05=to_char(to_date('2016-08-01','yyyy-mm-dd'),'yyyy') and imk06=to_char(to_date('2016-08-01','yyyy-mm-dd'),'mm')-1 END) WHERE tlf01 = 'P67011201' AND (tlf907 <> 0) AND tlf902 = '808' AND tlf903 = 'L13' AND tlf904 = '3000' AND tlf06 >= to_date('2016-08-01','YYYY-MM-DD') order by tlf06 各位大声，红色部分应该怎么写啊，执行提示缺少关键字； 我的目的很简单，如果发现月份为1月，就把imk05获取的年份减1，然后imk06=12就可以了。 |
