How we can create 2 left joined tables join with 3rd table?

[umerfa]

I have following 3 tables with linked fields

Details_Sales  table                                                  

• [Customers code]                                           
• [Product Code]

Customers table

• [Customer code]
• [Customer group]

The above 2 tables are linked with [Customer code] field

I have following 3rd table

Ranpak Support table

• [Ran product code]
• [ran customer group]
• [ran support]

I need to join Ranpak Support table and Details Sale table with double field link

[Ran product code] + [ran Customer group] 

How I get [Customer Group] (Customers table) field in Details Sales table to make its 2 fields link key with Ranpak support table ?

[paulcalvet]

Hello,

You can do something like that :

Load

[Customers code]                                         

[Product Code]

From Details_Sales

left join

Load

[Customers code]                                         

[Customer group]

From Details_Sales

From Customers

left join

[Ran product code] as [Customer group]

[ran customer group] as [Product Code]

[ran support]

from Ranpak Support