ACCESS FEED: Re: [MS_AccessPros] RE: FULL outer join

Jumat, 31 Juli 2015

Re: [MS_AccessPros] RE: FULL outer join

Oh, well!

To do a FULL OUTER JOIN in Access, you must do this:

SELECT A.*, B.*

FROM A LEFT JOIN B

ON A.Key = B.Key

UNION ALL

SELECT A.*, B.*

FROM B LEFT JOIN A

ON B.Key = A.Key

WHERE A.Key IS NULL;

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jul 31, 2015, at 6:58 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Duh – I mean a full outer join

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, July 31, 2015 9:50 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] left outer join

Pros, I would love to spend the time figuring this out, but feel like I should get this done faster than I would spend the time doing it.

How do I have Access sql perform this:

LEFT OUTER JOIN F3002 ON F3002.IXCMCU = F3002.IXMMCU AND F3002.IXITM = F3002.IXKIT

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808

beaerospace.com

Passion to Innovate. Power to Deliver

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.