Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try to post the structures for tables (Cpp_Sales, Cpp_Account , Cpp_Sales_P) or the joining keys between them
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.