C11/System/LOCOSOFT/IQD/Serv_Teile/Imvoice_No_Order_No.sql

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 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