Sunday, March 11, 2012

apply diff between two similar tables

I'm trying to find a way to do something like
select * from Table1
where {a,b,c} not in
(select a,b,c from Table2).
Without using concatenation on a,b,c.
(need it to apply 'diff' between two similar tables).
??:mad:
:confused:select * from Table1
where not exists
(select 1 from Table2
where a = Table1.a
and b = Table1.b
and c = Table1.c )

rudy
http://rudy.ca/

No comments:

Post a Comment