LEFT JOIN YTJH_YEAR Y ON R.ZB_ID=Y.ZB_ID AND y.data_date = to_date('${data_date}'||'0101','YYYYMMDD') AND IF('${data_date}' < '2018',(y.org_id =100100 or y.org_id =100),y.org_id =100100) |
最佳回答 |
||||
0
|
|