Toughie Query Problem

[james0816]

I am working with two tables (A and B).

TableA

ITNum Loc
1012 East
1023 East
1035 West
1095 West

TableB
PTNum Ring
1012 C
1035 D

I only want to display the records from TableA that do not have a corresponding record in TableB. ITNum=PTNum

I can do this if the column names were the same however, since they are different, I can not get it working.

Thx

 

[swampBoogie]

select * from tableA
where not exists (
select * from tableb
where tableA.ITNum = tableB.PTNum)

 

[r937]

alternative method:

select A.ITNum 
     , A.Loc
  from TableA as A
left outer
  join TableB as B
    on A.ITNum 
     = B.PTNum
 where B.PTNum is null

r937.com | rudy.ca