Viewing post 1 (of 1 total)
Why using left join? Do it more simple:
SELECT *
FROM dbo.xComp d
where not exists(
select * from dbo.xTask
where rowid=d.taskid)
October 3, 2003 at 12:49 am
#476910