SQL join syntax

[Anonymous]

Please help me the Join syntax for the below code

Select distinct

Sales_ID,

Code,

Item_No,    

LOSS_Date,

STAGE_Code,

ShippingCountry

From Cpp_Sales.APP_COMBINED

Left Join Cpp_Sales.OSC_DV ON B.OSC_ID = A.OSC_ID

Left Join Cpp_Account C ON C.ORG_ID = B.ORG_ID

Left Join Cpp_Sales_P.Item_Com ON OSC_ID = A.OSC_ID

[YoussefBelloum]

Hi,

Try to post the structures for tables (Cpp_Sales, Cpp_Account , Cpp_Sales_P) or the joining keys between them

[Ben_P]

If you're only joining on one field, you can just load the tables separately. QlikView will automatically make associations between fields that have the same name.