Re: Merging Two CSV files Based on Two Columns

[clueless newbie]

in reply to Merging Two CSV files Based on Two Columns

With regards to method 1: Your SQL is at fault for the completed file being empty. It should read (Note the "2")

      CREATE TABLE completed
      AS SELECT final2.username,HCDir2.branch,final2.date_modified
      FROM  HCDir2
      INNER JOIN final2
      ON final2.username = HCDir2.fullname

[TheCanadian]

Hi: clueless newbie

Thank you for your reply. This method interested me because I wanted to learn SQL as well; not to mention the slick short code to produce the product. I still cannot get this code to work even after the changes you suggested. Right now I am going to focus on straight PERL or PERL with the addition of Text::CSV or Text::CSV_XS.

I want to thank you as well for having a keen eye for anomalies in file names and variables. Keep up the good work. Sometimes a simple slip in names like this code causes the code to fail with little message as to the reason for the fail.

TheCanadian