有关left join 与*=的区别
我用下边的语句访问SQL Server2000中pubs库的job表,可是出来的结果是不一样的
1。select *
from jobs left join
(select top 10 * from jobs) a_tab
on jobs.job_id=a_tab.job_id
where a_tab.job_id is null
2。
select *
from jobs,
(select top 10 job_id from jobs) a_tab
where (jobs.job_id*=a_tab.job_id) and (a_tab.job_id is null)
请高手解释