Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: MINUS problem
Thanks for the hint about null, but the suggested SQL answers a differnt question than the one I seek to ask.
Perhaps the issue can be boiled down to this:
How may I use MINUS between two SELECTs that return a different number of columns? I thought I could add a NULL in place of the missing column, so:
1 (select distinct
2 gurmail_pidm, 3 gurmail_term_code, 4 gurmail_letr_code, 5 gurmail_date_printed
10 gurmail_pidm, 11 NULL, 12 gurmail_letr_code, 13 gurmail_date_printed
How should I make up for the missing column if not by NULL?
Thanks,
Phil
Received on Fri Mar 13 1998 - 00:00:00 CST