Query help please.

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

Hi I am new to SQL , I AM FINDING DIFFICULT JOIN 4 TABLES TO GETHER . I AM JOINING FIRST 2 TABLES WITH 4 CLOUMNS , BUT I AM UNABLE TO JOIN 3RD AND 4TH TABLES . PLEASE YOUR HELP WILL BE REALLY APPRIACIATED.

HERE IS 1ST 2 TABLES JOIN

[Item No_]

,[Gross Weight]

,[Reason Code]='RTN_DAMAGE'

,[Internet Order No_]

FROM [TBW_BI].[dbo].[Dreams house$Warehouse Returns] AS RE

JOIN [TBW_BI].[dbo].[Dreams house$Sales Invoice Line] AS LI

ON RE.[Item No_]=LI.[No_]

here are the colums and tables which I want to join :

[Ship-to Country Code] ,[Internet Order Reference] FROM [TBW_BI].[dbo].[Dreams house$Internet Order Header]

and

[Shipping Agent Code], [Internet Order Reference] FROM [TBW_BI].[dbo].[Dreams house$Internet Consignment]

final result must contain ,

order number , ship to city , gross weight , reason code and item.no

Please help.

Re: Query help please.

Anil_Babu_Samineni — Mon, 27 Mar 2017 01:56:54 GMT

First of all, This is Qlikview Community. You may move into Oracle Branch to discuss the same. For your Question

Note: Join table should be at least one column common like i mentioned alias name

Select [Item No_] as [No_]

,[Gross Weight]

,[Reason Code]

,[Internet Order No_]

FROM [TBW_BI].[dbo].[Dreams house$Warehouse Returns] AS RE where [Reason Code] ='RTN_DAMAGE';

Join Select * from [TBW_BI].[dbo].[Dreams house$Sales Invoice Line] AS LI ON RE.[No_]=LI.[No_];

Left Join

Select [Ship-to Country Code] ,[Internet Order Reference] FROM [TBW_BI].[dbo].[Dreams house$Internet Order Header];

Join

Select [Shipping Agent Code], [Internet Order Reference] FROM [TBW_BI].[dbo].[Dreams house$Internet Consignment];

topic Re: Query help please. in QlikView

Query help please.

Re: Query help please.