1 2 Previous Next 21 Replies Latest reply on Aug 8, 2016 2:31 AM by Mark Fraser

    syntax error for simple cusom sql join with .csv files

    Baron Medenwald

      I'm trying to add a few columns from one data source to another (I've tried the full join & data blending - both of those seemed to cause other complications that I'm hoping this join will erase) and am getting an odd error message.  Here's the code I'm using:

       

      select *
      from [d_nuc_002_crt_open_rebuttal_aging.csv]

      LEFT JOIN

      select
          [SRVR_NME],
          [Acquisition_Book_Category] as [Acquisition Group],
          [Rebuttal_Count]
      from [d_nuc_002_repurchase_osdet.csv]

      on ([d_nuc_002_crt_open_rebuttal_aging.csv].[ln_id]=[d_nuc_002_repurchase_osdet.csv].[ln_id])

       

      Both of the select statements work independently.  When I combine them and add the left join I get the following error:

      Microsoft JET database error 0x80004005: Syntax error in FROM clause.

       

      Would love some feedback on what the issue is.

        1 2 Previous Next