On 1/27/2014 12:57 PM, Jean-Christophe Deschamps wrote:
I'm trying to find the correct syntaxt for this, but I hit a syntax
error each time: either SQLite shokes on outer parenthesis or on union all.
(
select * from A where x in (subselectA)
left outer join
select * from B where y in (subselectB)
)
This part already doesn't make sense. "left outer join" can only appear
in the FROM clause - but that ends at the WHERE keyword. I can't even
begin to guess what you are trying to do here. What exactly are you
joining to what else, and on what condition?
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
