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(((convert(varchar(50), T2."invoice_type"))))) + (left(((convert(varchar(50), T1."invoice_number"))))) 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(((convert(varchar(50), T2."invoice_type"))))) + (left(((convert(varchar(50), T1."invoice_number")))))) <> '') and (T2."invoice_date" >= convert(date, '2019-01-01')))
-- order by "Order Number" asc