I found it.

The limit i 9 join.


>Hi all,
>How many tables is possible, in a single select sql, to link with a join clause? I have 14 table to link and the error message says:
>"SQL: Too many subqueries." is a wrong sql syntax or much tables ?
>
>a piece of code:
>
> FROM Tesdoc;
> LEFT JOIN Client ON Client.id == Tesdoc.idclient;
> LEFT JOIN Desdiv ON Desdiv.id == Tesdoc.iddesdiv;
> LEFT JOIN Rigdoc ON Rigdoc.idtesdoc == Tesdoc.id;
> LEFT JOIN Tipdoc ON Tipdoc.id == Tesdoc.idtipdoc;
> LEFT JOIN Tippor ON Tippor.id == Tesdoc.idtippor;
> LEFT JOIN Tippag ON Tippag.id == Tesdoc.idtippag;
> LEFT JOIN Tipsca ON Tipsca.id == Tesdoc.idtipsca;
> LEFT JOIN Tipspe ON Tipspe.id == Tesdoc.idtipspe;
> LEFT JOIN Tipasp ON Tipasp.id == Tesdoc.idtipasp;
> LEFT JOIN Cautra ON Cautra.id == Tesdoc.idcautra;
> LEFT JOIN Vettor ON Vettor.id == Tesdoc.idvettor;
> LEFT JOIN Banche ON Banche.codabi == Tesdoc.abi;
> LEFT JOIN Filiali ON Filiali.codabi == Tesdoc.abi AND Filiali.codcab == Tesdoc.cab;
>
>T.I.A.
>Dino