MySQL Forums
Forum List  »  Newbie

Too many tables; MySQL can only use 61 tables in a join
Posted by: Peter Jack
Date: May 08, 2018 07:05AM

select * from table
left join (select col1,col2,col3 from table2 where col1 = 'New') as ppr on ppr.col1 = table.col1
left join (select col1,col2,col3 from table2 where col1 = 'old') as ppn on ppn.col1 = table.col1 etc


i am left joining on table 2 more than 61 times and my where condition in table 2 different all the time e.g where col2 = 'Old' etc

I am trying to find a better way of writing this query can anybody help please

This is the error that occurs Too many tables; MySQL can only use 61 tables in a join

Options: ReplyQuote


Subject
Written By
Posted
Too many tables; MySQL can only use 61 tables in a join
May 08, 2018 07:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.