Feb 9, 2004, 6:17 AM
Post #1 of 4
a INTERSECT kind of question
I was wondering if anyone know how to perform a database search(query) by matching specified number of colums (not all columns) to intersect with another query and at the same time get the data that doesnt intersect.
Something like below:
select test1, test2, test3 from test intersect test1, test2, test4 from test;