C11/System/NAVISION/IQD/NW/verkaeufer_aktiv_struktur.sql

select T1."User ID" as "User Id",
	   T1."Employee No_" as "Employee No",
	   T1."Salesperson" as "Salesperson",
	   T2."No_" as "No",
	   T2."First Name" as "First Name",
	   T2."Last Name" as "Last Name",
	   T2."Name" as "Name",
	   T2."Status" as "Status",
	   T2."Inactive Date" as "Inactive Date",
	   T2."Termination Date" as "Termination Date",
	   'aktive Verkäufer' as "Verkäufer / Sonstige"
from ("NAVISION"."import"."User_Setup" T1 left outer join "NAVISION"."import"."Employee" T2 on ((((((T2."No_" = T1."Employee No_") and (T2."Status" = 0)) and (T2."Inactive Date" = convert(datetime, '1753-01-01 00:00:00.000'))) and (T2."Termination Date" = convert(datetime, '1753-01-01 00:00:00.000'))) and (T1."Salesperson" <> ' ')) and (T1."Salesperson" <> 'DIV')) and (T2."Client_DB" = T1."Client_DB"))
where (((T1."Salesperson" <> ' ') and (not T1."Salesperson" IN ('DIV','BMWREL'))) and ((convert(float, T1."Salesperson")) BETWEEN 100 AND 999))
-- order by "Salesperson" asc