外联结不允许使用in 和 or 语句。有什么其他解决方案吗?
select A.id from A,B where A.id = B.id(+) AND B.num in ('1','2','3')
想实现的结果是B.num in ('1','2','3')也实现外联结。
select A.id from A,B where A.id = B.id(+) AND B.num in ('1','2','3')
想实现的结果是B.num in ('1','2','3')也实现外联结。
select A.id
from A left join B
on A.id = B.id
where B.num in ('1','2','3')
(select id from B where num in ('1','2','3')) B1
where A.id = B1.id(+)