17,377
社区成员
发帖
与我相关
我的任务
分享
select t.ge_id,t.create_date,t1.empid,t1.date
from A t, (SELECT DISTINCT empid, DATE FROM B) t1
where t.ge_empid = t1.empid(+)
and to_char(t.create_date, 'YYYY-MM-DD')=t1.date(+)
--试试
select t.ge_id,t.create_date,t1.empid,t1.date
from A t, B t1
where t.ge_empid(+) = t1.empid
and to_char(t.create_date(+), 'YYYY-MM-DD')=t1.date
--或者
select t.ge_id,t.create_date,t1.empid,t1.date
from A t right join B t1 on (t.ge_empid = t1.empid
and to_char(t.create_date, 'YYYY-MM-DD')=t1.date)