Find the answer to your Linux question:
Results 1 to 3 of 3
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Aug 2002
    Location
    South Africa
    Posts
    9

    Accessing four tables at the same time?


    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?

  2. #2
    Linux Guru
    Join Date
    Oct 2001
    Location
    Täby, Sweden
    Posts
    7,578
    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.?

  3. #3
    Linux Engineer
    Join Date
    Apr 2003
    Location
    Sweden
    Posts
    796
    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..

    Regards
    Regards

    Andutt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •