Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have following 3 tables with linked fields
Details_Sales table
Customers table
The above 2 tables are linked with [Customer code] field
I have following 3rd table
Ranpak Support table
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 ?
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