db-derby-user mailing list archives

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