SQL Where values are not in another table

  • Home
  • SQL Where values are not in another table

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]

Select next available ID
Perl Push Array