Good News Everybody!
The new search engine is LIVE!
Please report any problems to david (at) midrange.com.
|
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 mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
