Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    16

    Unanswered: Access to Oracle SQL conversion help

    Hi guys... Need some help with my query

    I converted some Access query to Oracle, but I'm not getting the same number of records. Below are the 2 queries :

    Oracle SQL


    SELECT *
    FROM TOPS.VESSEL_CALL VES, TOPS.BERTHING BERTHING, TOPS.CNTR CNTR, TOPS.NOMINATED_VSL NOM
    WHERE ((VES.VV_CD = BERTHING.VV_CD)
    AND (VES.VV_CD = CNTR.DISC_VV_CD)
    AND (CNTR.NOM_LOAD_VV_CD = NOM.NOM_VV_CD(+))
    AND (CNTR.LOAD_VV_CD = VES.VV_CD(+)))


    Access SQL


    SELECT *
    FROM (((TOPS_VESSEL_CALL INNER JOIN TOPS_BERTHING ON TOPS_VESSEL_CALL.VV_CD = TOPS_BERTHING.VV_CD)
    INNER JOIN TOPS_CNTR ON TOPS_VESSEL_CALL.VV_CD = TOPS_CNTR.DISC_VV_CD)
    LEFT JOIN TOPS_NOMINATED_VSL ON TOPS_CNTR.NOM_LOAD_VV_CD = TOPS_NOMINATED_VSL.NOM_VV_CD)
    LEFT JOIN TOPS_VESSEL_CALL AS TOPS_VESSEL_CALL_1 ON TOPS_CNTR.LOAD_VV_CD = TOPS_VESSEL_CALL_1.VV_CD


    I suspect its the way the tables are joined for the Oracle version. Thanks in advance for the help
    Last edited by zedd; 01-06-04 at 21:55.

  2. #2
    Join Date
    Nov 2003
    Posts
    16
    Oh ya, I'm on 8i version if that matters

Posting Permissions

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