Joins in Tables

[stuwannop]

Hi All

I have two table that I want to join together. One is called "CRM Account" and the other is called "Account Spend".

My key field is going to be "accountno" which exists in both tables. However, there are various transactions in the "Account Spend" table that do not relate to any accounts in the "CRM Account" table. I want to exclude this data when I run the script as I am not interested in it - how do I do that in the script?

Thanks

Stu

[SunilChauhan]

load CRM Account table left join with Account Spent .

then it will take from CRM Account  and matching from Account Spent

[its_anandrjs]

Hi,

You have to load data like

CRMTable:

Load *

From CRM

Join(CRMTable)

Load *

From Account Spent

where exists(accountno);

Rgds

Anand