sql - fields that don't match -


i have 3 fields per row in table 1 want compare exact same fields per row in table 2

i have been playing around not in, not having luck. can help?

basically want see records both tables field 1, field 2, field 3 don't match in table 2

how written?

select *   table1 t1 full outer join   table2 t2        on t1.col1 = t2.col1        , t1.col2 = t2.col2        , t1.col3 = t2.col3  t1.col1 <> t2.col1        or t1.col2 <> t2.col2        or t1.col3 <> t2.col3 

Comments

Popular posts from this blog

c++ - Creating new partition disk winapi -

Android Prevent Bluetooth Pairing Dialog -

VBA function to include CDATA -