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
Post a Comment