SQL Help with two table

[ProgrammingStudent]

Here's the deal. I have two table but I want to include everything in table A that isn't in table B.

I have a list of product numbers in table A and I want to make a list of the one's in table B that haven't been used yet.

SELECT TableA.ProductN umer
FROM Table A Full Join TableB
ON TableA.ProductN umber <> TableB.ProductN umber

[amitpatel66]

Here's the deal. I have two table but I want to include everything in table A that isn't in table B.

I have a list of product numbers in table A and I want to make a list of the one's in table B that haven't been used yet.

SELECT TableA.ProductN umer
FROM Table A Full Join TableB
ON TableA.ProductN umber <> TableB.ProductN umber

Try this:

[code=sql]

SELECT productnumber FROM tableA WHERE productnumber NOT IN (SELECT productnumber from tableb)

[/code]

[ProgrammingStudent]

Thank you. It worked perfectly!

[amitpatel66]

Thank you. It worked perfectly!

You are welcome :) .