SELECT        TOP (100) PERCENT dbo.tMntPriceList.AsOfDate, dbo.tMasShift.ShiftName, dbo.tMasCustomer.CustomerCode, dbo.tMasCustomer.CustomerName,
                         dbo.tMasProduct.ProductCode, dbo.tMasProduct.ProductName, dbo.tMntPriceList.UnitPrice
FROM            dbo.tMntPriceList INNER JOIN
                         dbo.tMasCustomer ON dbo.tMntPriceList.RefID_Customer = dbo.tMasCustomer.RefID INNER JOIN
                         dbo.tMasShift ON dbo.tMntPriceList.RefID_Shift = dbo.tMasShift.RefID INNER JOIN
                         dbo.tMasProduct ON dbo.tMntPriceList.RefID_Product = dbo.tMasProduct.RefID
ORDER BY dbo.tMntPriceList.AsOfDate, dbo.tMasShift.ShiftName, dbo.tMasProduct.ProductCode, dbo.tMasCustomer.CustomerName