4 Replies Latest reply: Aug 9, 2018 1:39 PM by Neel Kapadia RSS

    INNER JOIN IN SQL SCRIPT

    Neel Kapadia

      Hi,

       

      I have a csv file containing a list of users.

       

      I want to write a query such that it retrieves info only for the users in the csv.

       

      I am trying to write something like:

       

      connections:
      SQL
      SELECT * FROM (
           SELECT
                A,
                B,
                C
           FROM
                Table1,
                Table2
           WHERE
                conditions..
      ) a 
      INNER JOIN (
           SELECT
                X,
                Y
           FROM
                (upload contents of csv file)
      ) b
      ON a.B = b.X;
      

       

      How do I load the csv file in the script with label SQL?

       

      OR, if I load the csv before the script as follows:

       

      [file]:
      LOAD
           @1 as A,
           @2 as B
      FROM [file-path]
      (txt, codepage is 28591, embedded labels, delimiter is ',', msq);
      

       

      How do I use the columns A,B in the SQL script?

       

      Thanks!