If you have for example 4 tables. And you want to get data from all 4 tables at the same time. Is it possible or not? I got it right to get data from 3 tables at the same time. But it doesn't work with 4 tables.
Is this query possible?
Printable View
If you have for example 4 tables. And you want to get data from all 4 tables at the same time. Is it possible or not? I got it right to get data from 3 tables at the same time. But it doesn't work with 4 tables.
Is this query possible?
What kind of tables are they? Do you intend to cross-reference between them, or do they have identical stucture and you wish to append them all to the result set? I know of no limitations that low for multitable queries. What queries did you use when you succeeded and failed, resp.?
Like dolda says, i cant belive there should be a limit of 3 tables in a query, what database did you run??
I have used many different databases and have runned bigger querys that have included more then 3 different tables. So that canīt be..
Post in an example.. 8-)
Regards