How many tables in sql can joined at a time?

Question

in SQL there is a join functionality to join two tables which having same primary key. but my question is that how many tables can joined in a single query? if you have qnswer tell me for inner join and for outer join also...

Answer 1

here is the link : https://www.quora.com/What-is-the-max-number-of-columns-or-tables-that-can-be-joined-using-JOIN-in-SQL?ch=3&share=b81fc546&srid=quyIu

Answer 2

meet bhanderi
Can you share something to support the finding? I'm interested if such limits are generally implemented for all DBMS, or is it some DBMS specific implementation.

Answer 3

meet bhanderi 👍

Answer 4

https://www.sololearn.com/learn/SQL/1865/

Hope this helps...!!!

Answer 5

I have found answer that, in inner join we can use 256 tables at a time and in outer joins we must have to use 2 tables at a time...

Answer 6

i think no limit in joining tables