topic SQL join syntax in QlikView

SQL join syntax

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: SQL join syntax

YoussefBelloum — Fri, 15 Dec 2017 15:17:58 GMT

Hi,

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

Re: SQL join syntax

Ben_P — Fri, 15 Dec 2017 15:27:29 GMT

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.