Below is not what you ask for but I'm not sure if it would be acceptable
for you ?
Select * from EE a where
not exist (Select 1 from A1 b where a.EEPOL# = b.AAPOL#) and
not exist (Select 1 from A2 c where a.EEPOL# = c.AAPOL#)
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Wednesday, April 02, 2008 12:51 PM
To: Midrange Systems Technical Discussion
Subject: SQL exception join: Left side now needs data combined from two
tables
I have a query that uses an exception join. I.e.
select * from EE exception join A1 on EEPOL# = AAPOL#
Some of the data in A1 is now being split off into a new table A2, so
data that used to be in A1 but is now in A2 is being returned as a
result in this query. I need the right side of this join to have the
rows from both A1 & A2. Pseudo-code:
select * from EE exception join (A1||A2) on EEPOL# = A1POL#
I know I could use a temporary file to combine A1 & A2, use the temp
file on the right side, and call it done, but I'm trying to learn
whether SQL has a way to handle this. I thought of UNION, but don't
think this will work for
an exception join. I tried:
select * from EE exception join
(select * from A1 union
select * from A2 ) on EEPOL# = AAPOL#
but no good.
Any ideas would be greatly appreciated.
TIA,
Dan
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
