select M.ID MemberID, E.[Exchequer-Code] Exchequer, M.FirstName +' '+ M.LastName Member, M.ClubName Club, O.OrderID OrderID, CONVERT(VARCHAR,O.OrderDate,103) OrderDate, D.ProductSKU SKU, N.Code, D.ProductName Product, D.Price, D.Quantity, D.TotalPrice, ISNULL(O.OrderSubTotal,0.00) OrderSubTotal, ISNULL(O.OrderDeliveryCharge,0.00)Carriage, O.CarriageNotes, ISNULL(O.OrderDiscount, 0.00) OrderDiscount, O.OrderDiscountReason, ISNULL(O.OrderTax,0.00) OrderVAT, ISNULL(O.OrderTotal,0.00) OrderGrandTotal from dbo.Ordertb O inner join dbo.OrderDetail D on D.OrderID = O.OrderID inner join dbo.[Direct-Product] P on P.ID = D.ProductID inner join dbo.Member M on M.ID = O.MemberID inner join dbo.[Member-Exchequer-Codes] E on E.MemberID = M.ID inner join dbo.[Nominal-Codes] N on N.ID = P.NominalCodeID
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.