Limit and Queries

[jonamua1971]

Hi
i just wanted to find out how many tables can one get data from to make a query. is there a limit? im in the process of making a query which will get data from 5 tables but im having problems.
Any help will be highly appreciated.

 

[jdraw]

Hi
i just wanted to find out how many tables can one get data from to make a query. is there a limit? im in the process of making a query which will get data from 5 tables but im having problems.
Any help will be highly appreciated.

Show us what tables you have and what you're trying to do.

 

[gemma-the-husky]

there may be a limit, but its far bigger than 5

start with two/three tables, and keep adding, so that you can see where your problem is occurring

 

[Guus2005]

When you get the Error Message that your Query is getting too complex, Just do as the error message describes, use subqueries. This means that you split your query in smaller parts (subqueries).