Query to identify items not in tableA that are in tableB 1

[awise]

Can someone assist me with a query that will return the records of Table A where those records are not in Table B

Comparing to inventory tables, one the master, the other the pricing table. Items were accidently deleted from the master, so I need to remove the associated record from the pricing table. Item Number is the primary key.

Thank you,

zaw

 

[bborissov]

SELECT TableA.*
FROM TableA
LEFT JOIN TableB ON TableA.PK = TableB.FK
WHERE TableB.FK IS NULL

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[awise]

Many thanks.

Your template worked perfectly for what I needed.

zaw