select distinct a.id,a.name,b.date,c.date
from a,
(select * from b where b.date=:start_date) b,
(select * from c where c.date=:end_date) c
where a.id=b.id (+)
and a.id=c.id (+)
...全文
279打赏收藏
这样的sql语句能变为数据窗口吗?
select distinct a.id,a.name,b.date,c.date from a, (select * from b where b.date=:start_date) b, (select * from c where c.date=:end_date) c where a.id=b.id (+) and a.id=c.id (+)