DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: JOIN and ORACLE

  1. #1
    Join Date
    Jan 2001
    Posts
    1
    I am debugging a query for an application that I am changing from using MSoft Access to Oracle. I am having some trouble getting the query to work and I think it may be due to the multiple joins. I have looked through all of my Oracle books and can't seem to figure out the problem. The code is posted below and any help would be greatly appreciated. Thanks.




    Attachments: SELECT PROJ_EXHIBIT.TITLE AS ExhibitTitle,
    PROJ_GRANT.Title AS GrantTitle,
    PROJ_INTERNET.Title AS InternetTitle,
    PROJ_MEDIA.Title AS MediaTitle,
    PROJ_OTHER.Title AS OtherTitle,
    PROJ_PRESENTATION.*,
    PROJ_PUBLICATION.*,
    PROJECT.*,
    L_PROJTYPE.CATEGORY,
    L_PROJTYPE.RANK,
    L_PROJTYPE.TYPEID
    FROM ((((((((PROJECT LEFT JOIN PROJ_EXHIBIT
    ON PROJECT.PROJID = PROJ_EXHIBIT.PROJID)
    LEFT JOIN PROJ_GRANT
    ON PROJECT.PROJID = PROJ_GRANT.PROJID)
    LEFT JOIN PROJ_INTERNET
    ON PROJECT.PROJID = PROJ_INTERNET.PROJID)
    LEFT JOIN PROJ_MEDIA
    ON PROJECT.PROJID = PROJ_MEDIA.PROJID)
    LEFT JOIN PROJ_OTHER
    ON PROJECT.PROJID = PROJ_OTHER.PROJID)
    LEFT JOIN PROJ_PRESENTATION
    ON PROJECT.PROJID = PROJ_PRESENTATION.PROJID) LEFT JOIN PROJ_PUBLICATION
    ON PROJECT.PROJID = PROJ_PUBLICATION.PROJID) LEFT JOIN L_PROJTYPE
    ON PROJECT.TYPE = L_PROJTYPE.TYPE)

    WHERE (((PROJECT.FACID)=#Session.ID#))
    ORDER BY L_PROJTYPE.RANK, L_PROJTYPE.CATEGORY, PROJECT.Type, PUBDATE desc



  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    The problem is that Oracle does not yet support ANSI-92 JOIN syntax. You will have to do all your joins in the WHERE clause.

    Sorry,

    - Chris

Posting Permissions

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


Click Here to Expand Forum to Full Width