How to join the tables by three criteria?

[#1]

Dear Exparts,

        I have three tables and I would like to join these table for the aggregation purpose.

My purpose is to show which Ac_No are belongs to which Department. But I would like to show only Ac_No in Customer Account(20698586763665702) these have same Reference_No and not to show in (330601017). Hope to help me.

[#2]

Try

Load * inline

e.g.

LOAD * INLINE

[    Start, End, Order

     01:00, 03:35, A

     02:30, 07:58, B

     03:04, 10:27, C

     07:23, 11:43, D ];

[vardhancse]

Sample script:using left join

Result will be 1 single table

Table_1:

Load

Reference_No,

Ac_No,

Product;

Left join(Table_1)

Load

Ac_No,

Department;

Left join(Table_1)

Load

Product,

Department;

[#4]

Hi kyaw,

can you elaborate little more. The contents which you have mentioned is not matching with the pictures you have shown.

Regards,

Sangeetha S

[#5]

Dear all,

  it can't get the required data by Load inline and left join. Let me explain about below picture.

it has the same Reference_No and I would like to show the customer Ac_No(20611206001101401) belongs to (Account Transfer) Description.First criteria is like below,

In second criteria, there is no Ac_No like(330601017) and it can only join by Product.

Second criteria will be like below,

These above two criteria will be in a single table. After that I can extract the Ac_No belongs to each department. Hope to understand me. 

Best Regards,

Kyaw Myo Tun