1 Reply Latest reply: Feb 8, 2017 4:29 PM by Stefan Wühl RSS

    Left Join SQL Select

    james eckstein

      I have the following code

       

       

       

      ECW_Temp:
      LOAD
      SiteName,
            fromProviderName,
            fromProviderNPI as ProviderNPINumber,
            toProviderName,
            toProviderNPI,
            ReferralDate,
            referralType
      FROM
      [\\Server]
      (txt, codepage is 1252, embedded labels, delimiter is ',', msq)
      Where referralType ='O'
      ;



      Left Join (ECW_Temp)
      SQL Select
      p.ProviderNPINumber
      ,p.ProviderType
      ,p.ProviderTypeCategory

      From Source p
      Where
      p.RowIsCurrent='Y'
         AND
         p.DeletedBy IS NULL
         and
         p.ProviderNPINumber IS NOT NULL
      ;

       

       

      When I look at the resulting table "ECW_Temp" I am seeing only null value for

      ProviderType and ProviderTypeCategory. I have manually checked and I know there are ProviderNPINumber's that match to each other from both sources.


      Any ideas?


       

        • Re: Left Join SQL Select
          Stefan Wühl

          Don't JOIN but keep the tables linked (an outer JOIN also could do the job)

           

          Then create a table chart with  fields fromProviderName, ProviderNPINumber, ProviderType and ProviderTypeCategory.

           

          This table should allow you check the field values of your key in both tables and may give us a hint why the match doesn't work.