RE: SQL join question

[rob@xxxxxxxxx]

Submit a DCR?

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Metz, Zak" <Zak_Metz@xxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/26/2003 02:47 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc
"Creed, Andrea" <Andrea_Creed@xxxxxx>
Subject
RE: SQL join question






So how come we can't do full outer joins? Supwitdat?

> -----Original Message-----
> From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
> 
> SELECT ADAM1.CHAR1, ADAM2.CHAR1, ADAM1.CHAR2, ADAM2.CHAR2
> FROM ADAM1 LEFT JOIN ADAM2 
>      ON ADAM1.CHAR1 = ADAM2.CHAR1 
> UNION 
> SELECT ADAM1.CHAR1, ADAM2.CHAR1, ADAM1.CHAR2, ADAM2.CHAR2
> FROM ADAM1 RIGHT EXCEPTION JOIN ADAM2 
>      ON ADAM1.CHAR1 = ADAM2.CHAR1 
 
NOTICE: This E-mail may contain confidential information. If you are not 
the addressee or the intended recipient please do not read this E-mail 
and please immediately delete this e-mail message and any attachments 
from your workstation or network mail system. If you are the addressee 
or the intended recipient and you save or print a copy of this E-mail, 
please place it in an appropriate file, depending on whether 
confidential information is contained in the message. 
 
 

_______________________________________________
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.