Select * from before b exception join after a on b.id=a.id and b.data=a.data
Union all
Select * from after a exception join before b on a.id=b.id and a.data=b.data
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: Thursday, March 10, 2011 8:39 AM
To: Midrange Systems Technical Discussion
Subject: Full outer join to show differences
Hi,
I'm comparing 2 tables after a test with a full outer join ie
select * from before b full outer join after a on b.id=a.id
But I only want to see the data that's different in the after table or not there at all, ie null in that select.
So I add
where a.data<>b.data
This now excludes the missing after lines.
So I need something like
select * from before b full outer join after a on b.id=a.id
where a.data<>b.data or
b.data= null
How do I get those null rows?
--
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.
________________________________
Notice from Bob Evans Farms, Inc: This e-mail message, including any attachments, may contain confidential information that is intended only for the person or entity to which it is addressed. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message and any attachments.
midrange.com
