Inner Join in SQL format to Qlikview

[Anonymous]

Hi,

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

Thanks

Mazda

[rajeshqvd]

Have you pulled tables from SQl...?

if it like

Table1:

Load *

From dbo.customer;

inner join

Table2:

Load *

From dbo.Operator;

[petter · Accepted solution]

In your load script you can have this:

LIB CONNECT TO 'SQLDB';

SQL

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

;

[Anonymous]

Thanks Petter!