Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    6

    Question Unanswered: IQ: max Outer Joins

    What is the maximum amount of tables that can be Outer Joined in a single Sybase IQ statement?

  2. #2
    Join Date
    Sep 2004
    Location
    Stockholm, Sweden
    Posts
    28
    A single query may reference up to 128 tables.

    see http://manuals.sybase.com/onlinebook...iqg1250e/iqref
    chapter "Physical Limitations"

  3. #3
    Join Date
    Nov 2004
    Posts
    6
    Isn't the manual refering to Inner Joins?

    If I Outer Join on a few tables, I start running into problems.
    I don't get the same problems if run the same sized Select on our ASE server.

Posting Permissions

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