SQL Where values are not in another table
[sql]
select TCode
from Tracking
where not exists (select *
from Task
where Task.TCode = Tracking.TCode
)
[/sql]
[sql]
select TCode
from Tracking
where not exists (select *
from Task
where Task.TCode = Tracking.TCode
)
[/sql]