How to join two tables as per below where clause

[#1]

Hi,

I am a newbie in qlikview and quite unaware of qlikview scripting...

please help me in joining these two tables as per the below sql statement.

select ORGANIZATION_CODE, GROSS_WRITTEN_PREMIUM, DISCOUNT, OTHER_CHARGES, GST, COMMISSION1, COMMISSION2, NET_WRITTEN_PREMIUM, TRANSACTION_NUMBER

from DIM_ORGANIZATION, FT_PREMIUM_TRANSACTION

where DIM_ORGANIZATION.ORGANIZATION_KEY = FT_PREMIUM_TRANSACTION.COMPANY_PARTY_KEY

Please help me its little urgent..

Many Thanks

Kriti

[#2]

Also I have prepared separate QVDs for both the tables..

[#3 · Accepted solution]

Try somenthing like this

LOAD   
ORGANIZATION_CODE, 
GROSS_WRITTEN_PREMIUM,
 DISCOUNT,
 OTHER_CHARGES,
 GST, COMMISSION1,
 COMMISSION2,
 NET_WRITTEN_PREMIUM,
 TRANSACTION_NUMBER;
SQL SELECT 
ORGANIZATION_CODE, GROSS_WRITTEN_PREMIUM, DISCOUNT, OTHER_CHARGES, GST, COMMISSION1, COMMISSION2,
 NET_WRITTEN_PREMIUM,
 TRANSACTION_NUMBER
 FROM        
DIM_ORGANIZATION INNER JOIN FT_PREMIUM_TRANSACTION  ON 
DIM_ORGANIZATION.ORGANIZATION_KEY = FT_PREMIUM_TRANSACTION.COMPANY_PARTY_KEY;

[#4]

Thanks Pedro