compare two columns

[noizee666]

Hi,

I have two tables in the same database. I want to compare one column from table A to table B. If a value from a.column is not in b.column this value should be returned.

The table A could have same values in it. Values in table B exists only one time.
example:
Column Table A Column Table B
1 1
1 2
2 4
2 5
3 7
3
3
3
4
5
5
5
6
6
7
7

The SQL statement should return 3 and 6 in this case. Because 3 and 6 is in Column A but not in Column B,


Thanks.

noizee
excuse my bad english

 

[swampBoogie]

select distinct c from a
where c not in (select c from b)

 

[carp]

SELECT colB FROM tableB
MINUS
SELECT colA FROM tableA;

 

[swampBoogie]

Minus is not an ANSI SQL feature.

 

[carp]

Ach! How right you are!!