Hi All, I wrote one query as SELECT ProdOrder.No_, ProdOrder.Description, ProdOrder.Status, ProdOrder.Quantity,ProdOrder.[Location Code],ProdOrder.[Source No_],Table1.[Unit Cost],Table2.[Quantity on Hand] LEFT OUTER JOIN (SELECT No_, [Customer No_],[Unit Cost] FROM [Company Name$Item] AS Table1 ON ProdOrder.[Source No_] = Table1.No_ LEFT OUTER JOIN (SELECT [Item No_], ISNULL(SUM(Quantity), 0) AS [Quantity on Hand] FROM [Company Name$Item Ledger Entry] GROUP BY [Item No_]) AS Table2 ON ProdOrder.[Source No_] = Table2.[Item No_] WHERE (ProdOrder.Status = 3) The PK of Prod Table is (Status, No_). Now, i have one more table called customer which is related to Item Table by Item.Customer = Customer .[No_]. I want to get the name of customer. The problem is that ProdOrder Table is my main table but there is no link with customer Table ProdOrder Table is linked to Item as shown in the query.