On 1/16/2014 5:21 AM, Rob Golsteijn wrote:
SELECT * FROM C
LEFT JOIN A ON A.a*A.a + B.b*B.b = C.c*c.c
LEFT JOIN B ON A.a*A.a + B.b*B.b = C.c*c.c;
I'm not sure how SQLite interprets this query. In any case, it doesn't
make much sense. I suspect you are looking for something like this:
SELECT * FROM A, B, C
WHERE A.a*A.a + B.b*B.b = C.c*C.c;
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
