3 Replies Latest reply: May 1, 2012 5:22 AM by 908002 RSS

    iSQL - SQLPLUS Join Error

    931866
      I have the following query, it is working just fine using iSQL on an Oracle 10gR2 server but not working on the SQLPLUS Oracle 10gR2 server (Two different machines).

      SELECT TERM.TERMINAL_ID
      , TERMINAL_NOMENCLATURE
      , FUNDING_STATUS
      , LEAD_AGENCYSERVICE
      , DESCRIPTION
      , LEAD_MAJCOM
      , TERMINAL_COMMENTS
      , TERMINAL_PICTURE
      , TERM.TIME_STAMP
      FROM RIVET.TBL_TERMINAL TERM
      JOIN RIVET.TBL_TERMINAL_TO_WAVEFORM TERM_WF ON TERM_WF.TERMINAL_ID = TERM.TERMINAL_ID
      JOIN RIVET.TBL_WAVEFORM_STANDARD WF ON WF.WAVEFORM_STANDARD_ID = TERM_WF.WAVEFORM_STANDARD_ID ORDER BY TERMINAL_NOMENCLATURE;

      The reason it does not work is FUNDING_STATUS is in both the TBL_TERMINAL and TBL_WAVEFORM_STANDARD (And it shouldn't work unless I use TERM.FUNDING_STATUS)

      The question I have is why is it working in the iSQL when it shouldn't?