General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only