select distinct T1."order_number" as "Order Number",
	   T1."invoice_number" as "Invoice Number_ohne_type",
	   T2."invoice_type" as "Invoice Type",
	   (left((((T2."invoice_type"))),1)) + (left((((T1."invoice_number"))),6)) as "Invoice Number"
from ("dbo"."invoices" T2 left outer join "dbo"."labours" T1 on (T1."invoice_number" = T2."invoice_number") and (T1."invoice_type" = T2."invoice_type"))
where ((((left((((T2."invoice_type"))),1)) + (left((((T1."invoice_number"))),6))) <> '') and (T2."invoice_date" >= convert(date, '2019-01-01')))
-- order by "Order Number" asc