Re: 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.