Query help please.

[ngreddy1982]

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.

[Anil_Babu_Samineni]

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];