Women in Technology

Hear us Roar



Article:
  The Outer Limits of SQL JOINs
Subject:   Outer join with >1 condition
Date:   2002-06-25 09:33:11
From:   jonathan.spencer@citex.com
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!