db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John English <john.fore...@gmail.com>
Subject SQL: JOIN syntax
Date Sun, 18 Nov 2012 17:14:39 GMT
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!

John English

View raw message