Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: Oracle 8i inner join and left join problem

    i receive this error:
    ORA-00933: SQL command not properly ended
    when i try to execute my query. Can someone help me... I'm using Oracle 8i.
    Below is my query:
    SELECT TOPS.VESSEL_CALL.VSL_NM, TOPS.VESSEL_CALL.IN_VOY_NBR, TOPS.VESSEL_CALL.VSL_BERTH_DTTM, TOPS.CNTR.CNTR_NBR, TOPS.CNTR.DISC_SLOT_OPR_CD, TOPS.CNTR.CNTR_OPR_CD, TOPS.CNTR.PURP_CD, TOPS.CNTR.ISO_SIZE_TYPE_CD, TOPS.CNTR.SIZE_FT, TOPS.CNTR.STATUS, TOPS.CNTR.SPECIAL_DETAILS, TOPS.CNTR.PLOAD, TOPS.CNTR.PDISC1, TOPS.CNTR.PDEST, TOPS.CNTR.DECLR_WT, TOPS.NOMINATED_VSL.VSL_NM, TOPS.NOMINATED_VSL.OUT_VOY_NBR, TOPS.NOMINATED_VSL.ETB_DTTM, TOPS.VESSEL_CALL.VSL_ETD_DTTM, TOPS.CNTR.CREATE_DTTM, TOPS.CNTR.CREATE_ORG_CD
    FROM TOPS_CNTR INNER JOIN TOPS_VESSEL_CALL ON TOPS_CNTR.DISC_VV_CD = TOPS_VESSEL_CALL.VV_CD LEFT JOIN TOPS_NOMINATED_VSL ON TOPS_CNTR.NOM_LOAD_VV_CD = TOPS_NOMINATED_VSL.NOM_VV_CD;

    Thanks in advance

  2. #2
    Join Date
    Oct 2003
    Posts
    2
    Opps.. forget to change TOPS_CNTR.DISC_VV_CD to TOPS.CNTR.DISC_VV_CD.. sorry.. here is my query again.
    SELECT TOPS.VESSEL_CALL.VSL_NM, TOPS.VESSEL_CALL.IN_VOY_NBR, TOPS.VESSEL_CALL.VSL_BERTH_DTTM, TOPS.CNTR.CNTR_NBR, TOPS.CNTR.DISC_SLOT_OPR_CD, TOPS.CNTR.CNTR_OPR_CD, TOPS.CNTR.PURP_CD, TOPS.CNTR.ISO_SIZE_TYPE_CD, TOPS.CNTR.SIZE_FT, TOPS.CNTR.STATUS, TOPS.CNTR.SPECIAL_DETAILS, TOPS.CNTR.PLOAD, TOPS.CNTR.PDISC1, TOPS.CNTR.PDEST, TOPS.CNTR.DECLR_WT, TOPS.NOMINATED_VSL.VSL_NM, TOPS.NOMINATED_VSL.OUT_VOY_NBR, TOPS.NOMINATED_VSL.ETB_DTTM, TOPS.VESSEL_CALL.VSL_ETD_DTTM, TOPS.CNTR.CREATE_DTTM, TOPS.CNTR.CREATE_ORG_CD
    FROM TOPS.CNTR INNER JOIN TOPS.VESSEL_CALL ON TOPS.CNTR.DISC_VV_CD = TOPS.VESSEL_CALL.VV_CD LEFT JOIN TOPS.NOMINATED_VSL ON TOPS.CNTR.NOM_LOAD_VV_CD = TOPS.NOMINATED_VSL.NOM_VV_CD;

Posting Permissions

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