-
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
-
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
