This content has been marked as final. Show 3 replies
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
( 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