запрос выборки из трех таблиц
SELECT c.name,c.name2,c.name1,c.name0
FROM ((client As a FULL OUTER JOIN client_kontact AS b ON (b.id_ins=a.id))
FULL OUTER JOIN client_out AS c ON (c.id=b.id_out))
WHERE (a.id=2) AND (c.open>0) ORDER BY c.name0,c.name1,c.name2,c.name
не проходит в
SQLlte Administrator 09.07.2012 19:23:23: SQL Error: RIGHT and FULL OUTER JOINs are not currently supported <SELECT c.name,c.name2,c.name1,c.name0
FROM ((client As a FULL OUTER JOIN client_kontact AS b ON (b.id_ins=a.id))
FULL OUTER JOIN client_out AS c ON (c.id=b.id_out)) WHERE (a.id=2) AND (c.open>0) ORDER BY c.name0,c.name1,c.name2,c.name
>
Не поддерживается запрос с использованием
FULL OUTER JOIN?
Я правильно понимаю?