Results 1 to 3 of 3

Thread: Join

  1. #1
    Join Date
    Dec 1969

    Default Join

    can one join many (more than 4) tables together using (join... on) to achieve the appearance of an unnormalised table?<BR>For ex, i have a table that stores bug info but the owner id, the severity id, priority id, and the category id are just numbers I want to join the tables(bug, Sev, Pri, Cat and Owner) so my results will include the owners name and the severity, priority level etc? I run into problems if i try to join more than two tables?<BR>i am writing the select statemnet in an asp page that connects to an access db.<BR>Thank you

  2. #2
    Join Date
    Dec 1969

    Default No theoretical limit...

    ...but I suppose that Access might start bogging down if you got *too* many. I know I have created 3 and 4 table joins with no problems noticed. I don&#039;t think I&#039;ve ever used more than 4, though. Just because if data gets that complex, then I tend to rethink the problem.<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: Join

    In SQL Server you can join up to 16 tables,don&#039;t know about Access,but of cause it should be less than in sql...

Posting Permissions

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