| Mutltible colums with MINUS-criteria [message #371903] |
Tue, 19 December 2000 02:01  |
Karri Lahtela
Messages: 16
Registered: November 2000
|
Junior Member |
|
|
Hi
I know this:
SELECT PRODUCT FROM tab_a MINUS SELECT PRODUCT FROM tab_b
But I need also ADDRESS from tab_a with that same 'PRODUCT FROM tab_a MINUS SELECT PRODUCT '-criteria
Thanks for help!
|
|
|
|
| Re: Mutltible colums with MINUS-criteria [message #371912 is a reply to message #371903] |
Tue, 19 December 2000 16:12  |
chandra
Messages: 31
Registered: October 2000
|
Member |
|
|
In order to use the set operators (Union, Intersect, minus, union all), it is necessary that the selected number of columns from both the tables should be the same..
You can try this out, if I understood your problem correctly.
select product,address from tab_a where product in(select product from tab_a minus select product from tab_b);
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
