3 Replies Latest reply: Oct 8, 2015 9:48 PM by arjun rao RSS

    using right join incorrectly

      Hi .. I'm a newbie and trying a simple script with the intent of a RIGHT JOIN

       

      Basically - I want all of the hostnames from the dSeries table and only the matching ones from the ODBC load (Snapshot) table.

       

       


      dSeries:
      LOAD PROD as 'dSeriesENV',
      Hostname as 'dSeriesHostname',
      ShortHostname as 'hostname'
      FROM
      [C:\Users\v374914\Desktop\dSeries_agents_20150901.xlsx]
      (
      ooxml, embedded labels, table is BOTH);

      right join (dSeries)

      ODBC CONNECT TO REPO_ODBC (XUserId is SUWDDRFNfKYGWRVMTbcSD, XPassword is CEaFfSFMNDNEWUZR);
      Snapshot:
      select hostname
      , status as 'itamstatus'
      , osplatform as 'itamosplatform'
      , os as 'itamos'
      , osversion as 'itamosversion'
      from itam_reporting.reporting.snapshothw_current
      where sigappitnonit = 'vzw';


      Any ideas?