
toshesh
Novice
Feb 9, 2004, 6:17 AM
Post #1 of 4
(8574 views)
|
a INTERSECT kind of question
|
Can't Post
|
|
Hi, 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;
|