QUERY QUESTION

[bakerm]

Hello.

I have what is probably a very basic SQL question for you guys but is driving me crazy.

I have two tables: A and B

Example:

Table A has 500 rows that meet certain search criteria.
Table B has 450 rows that meet the same search criteria used for table A.

The tables should return the same number of rows.

Question:

How would I write a query that would return the 50 rows that exist in table A but not in table B?

Thanks in advance for any help!

 

[MeanGreen]

Try this:

Select a.* from A left outer join B
on A.column1 = B.column1
and A.coumn2 = B.column2
where b.Column1 is null

Hope this helps.

 

[yu217171]

If you have some sort of common field between the two tables, you can do a left or right outer join to get the rows that don't match.


HTH,

Keith