John English <[email protected]> writes: > Can anyone tell me what the correct syntax is to make this join work? > > SELECT * from a,b LEFT JOIN c ON a.foo=c.foo AND b.bar=c.bar; > > That is, I want the crossproduct of a and b, with columns from c when > they correspond to rows in BOTH a and b, and nulls if not.
Hi John, You could try CROSS JOIN: SELECT * from a CROSS JOIN b LEFT JOIN c ON a.foo=c.foo AND b.bar=c.bar -- Knut Anders
