||The Outer Limits of SQL JOINs|
|Subject:||Outer join with >1 condition|
I need to do an outer join between two tables where the join uses two columns in each table - eg a.company=b.company AND a.project=b.project (I know, bad design - happily not by me ;-). I can't get this to work - I've tried various combinations of syntax - and I can't find any references to this type of join anywhere, all the examples use just one condition. Is that because it isn not possible, or just because it is unusual?
Any help much appreciated!