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/
Sunday, March 11, 2012
apply diff between two similar tables
Labels:
apply,
concatenation,
database,
diff,
likeselect,
microsoft,
mysql,
oracle,
select,
server,
similar,
sql,
table1where,
table2,
tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment