Haven't tested it, but shouldn't it be
select * from EE exception join A1 on EEPOL# = AAPOL#
UNION
select * from EE exception join A2 on EEPOL# = AAPOL#
??
-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Dan
Envoyé : mercredi 2 avril 2008 19:51
À : Midrange Systems Technical Discussion
Objet : 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
