6 Replies Latest reply: Feb 17, 2016 4:55 AM by Sangram Reddy RSS

    how to use SQL Query

    Prasanta Kumar

      Hi,

       

      Can i use the below SQL query directly while loading the data into Qlik sense. So that it will only load where the below query works and pull the necessary data from SQL database.

       

      SELECT Customers.CustomerName, Orders.OrderID

      FROM Customers

      LEFT JOIN Orders

      ON Customers.CustomerID=Orders.CustomerID

      ORDER BY Customers.CustomerName;


      Thanks