select T1."order_number" as "Order Number",
	   T1."order_position" as "Order Position",
	   T1."labour_type" as "Labour Type",
	   T2."code" as "Code_Labour_Types",
	   T2."description" as "Description_Labour_Types",
	   T3."order_number" as "Order Number_Labours",
	   T3."order_position" as "Order Position_Labours",
	   T3."order_position_line" as "Order Position Line_Labours",
	   '0' + (rtrim((convert(varchar(50), T4."subsidiary")))) as "Subsidiary_Labours",
	   T3."is_invoiced" as "Is Invoiced_Labours",
	   T3."invoice_type" as "Invoice Type_Labours",
	   T3."invoice_number" as "Invoice Number_Labours",
	   T3."employee_no" as "Employee No_Labours",
	   T3."mechanic_no" as "Mechanic No_Labours",
	   T3."labour_operation_id" as "Labour Operation Id_Labours",
	   T3."is_nominal" as "Is Nominal_Labours",
	   T3."net_price_in_order" as "Net Price In Order_Labours",
	   T3."rebate_percent" as "Rebate Percent_Labours",
	   T3."goodwill_percent" as "Goodwill Percent_Labours",
	   T3."charge_type" as "Charge Type_Labours",
	   T3."text_line" as "Text Line_Labours",
	   10 as "AW/Std.",
	   ((convert(float, T3."time_units"))) / 10 as "verk. Std.",
	   'verk. Std.' as "Zeitkategorie",
	   '' as "Zeitkategorie2",
	   T4."employee_number" as "Employee Number_Employee",
	   T4."name" as "Name_Employee",
	   (rtrim((convert(varchar(50), T4."employee_number")))) + ' - ' + T4."name" as "Monteur",
	   T5."invoice_number" as "Invoice Number_Invoices",
	   T5."invoice_date" as "Invoice Date_Invoices",
	   T5."invoice_date" as "Datum",
	   T3."time_units" as "Time Units_Labours",
	   (convert(float, T3."time_units")) as "Time_Units_Zahl"
from ("dbo"."invoices" T5 left outer join ((("dbo"."order_positions" T1 left outer join "dbo"."labour_types" T2 on T1."labour_type" = T2."code") left outer join "dbo"."labours" T3 on T1."order_number" = T3."order_number") left outer join "dbo"."employees" T4 on T3."mechanic_no" = T4."employee_number") on (T3."invoice_number" = T5."invoice_number") and (T3."invoice_type" = T5."invoice_type"))
where (((convert(float, T3."time_units"))) <> 0)
-- order by "Order Number" asc,"Order Position" asc