I have two nominally identical tables (containing old and newer versions of the same data), and I want all the entries from the committed table where there *isn't* a matching entry in the working table. If you can tell me a more efficient way to do this I'd be very happy :)
The left outer join gives you a line for every line in the committed table, but where there's no matching line in the working table you get nulls in the half of the data that came from the working table. engid is in fact the key for each table.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
timeasmymeasure
no subject
Date: 2009-06-26 11:35 am (UTC)The left outer join gives you a line for every line in the committed table, but where there's no matching line in the working table you get nulls in the half of the data that came from the working table. engid is in fact the key for each table.