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. Everything I've tried gives me something like
"Column 'A.FOO' is not in any table in the FROM list" I know I'm probably being stupid, but please help anyway! TIA, -- John English
