Query questions

[Dennis Villareal]

we take orders and they show up in a few tables. one table in perticular is
for upcoming rollings. the orther is for all the orders in the system. they
both have the same order numbers just if it is booked to a rolling it shows
in in the other. is there a way to run a query that shows only the orders in
the system that is not booked to a rolling in the other table? so "A" is all
orders in system and "B" is all orders booked to the rolling

if orders from "A" appeatr in "B" do not show up in the query

 

[Lord Kelvan]

select *
from tablea
where ordernum not in (
select ordernum
from tableb)

hope this helps

Regards
Kelvan