Re: Hi! All
From: ChrisF <chris.freel_at_gmx.ch>
Date: 5 Jul 2006 09:02:48 -0700
Message-ID: <1152115368.636954.123810_at_75g2000cwc.googlegroups.com>
Date: 5 Jul 2006 09:02:48 -0700
Message-ID: <1152115368.636954.123810_at_75g2000cwc.googlegroups.com>
[Quoted] Can I play too?
SELECT T1.COL1, 'T1' FROM T1, T2
WHERE T1.COL1 = T2.COL1 (+) AND T2.COL1 IS NULL
UNION
SELECT T2.COL1, 'T2' FROM T1, T2
WHERE T2.COL1 = T1.COL1 (+) AND T1.COL1 IS NULL;
"NOT IN" constructs can be inefficient.
[Quoted] Doing left/right joins and excluding the NULL values is in my
experience faster.
Received on Wed Jul 05 2006 - 18:02:48 CEST