Provide a list of all Labour Designations set up in the RentalPoint Database
SELECT
G.Group_code AS [Product Group],
G.group_descV6 AS [Group Description],
IM.category AS [Product Category],
C.cat_descV6 AS [Category Description],
IM.product_code AS [Product Code],
IM.on_hand AS [Quantity Owned],
IM.descriptionV6 AS [Product Description],
IM.PrintedDesc AS [Printed Description],
IM.DefaultRateForUnassigned as [Default Rate for Unassigned Crew],
L.Labour_Rate as [Labour Rate]
FROM dbo.tblInvmas AS IM LEFT OUTER JOIN
dbo.tblGroup AS G ON G.Group_code = IM.groupFld LEFT OUTER JOIN
dbo.tblCategory AS C ON C.category_code = IM.category LEFT OUTER JOIN
dbo.tblInvmas_Labour_Rates as L on IM.ID = L.tblInvmasID
WHERE (IM.product_type_v41 = 1)
ORDER BY [Product Group], [Product Category], [Product Code]