17,089
社区成员
发帖
与我相关
我的任务
分享
(1)select * from scott.DEPT t , (select * from scott.bonus where job = '') a where t.dname = a.ename(+)
(2)select * from scott.DEPT t , (select * from scott.bonus where job = '1') a where t.dname = a.ename(+)
语句(1)有数据,(2)没有数据