3 Replies Latest reply: Jul 6, 2018 12:42 AM by mazda miata RSS

    Inner Join in SQL format to Qlikview

    mazda miata



      Im quite new in Qlikview and i have a simple inner join SQL script below:


      How do i put this SQL inside Qlikview using OLEDB connection?



      select a.customer, a.Operator, Date

      From dbo.customer a

      Inner Join

      ( Select customer, Operator, Min (Date) as Firsttransaction From dbo.customer

      Group by customer, Operator) b

      on a.customer = b.customer  and a.Date = b.Firsttransaction