Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009

    Unhappy Unanswered: Maximum number of tables in join and left join

    Hello everyone!

    Does anybody knows which is the maximum number of tables that I can use in a join in DB2 (v9.5)?

    I have to run a query with 25 tables and I know that in Oracle I can use only 6 in a join.

    Note that particularly all of those tables have thousands (some of them hundreds) of rows..!

    Thank you in advance,

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Search the online documentation for "SQL Limit". By the way, I think you are mistaken about Oracle allowing only 6 joined tables...
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jul 2009
    Thank you, I will look for it.

    I have to agree with you...I migth be wrong about Oracle...

Posting Permissions

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