SELECT DISTINCT EliteUser.COM.NAME
FROM EliteUser.IEE INNER JOIN
EliteUser.COM ON EliteUser.IEE.COMID = EliteUser.COM.ID LEFT JOIN
EliteUser.EBI ON EliteUser.IEE.ID = EliteUser.EBI.IEEID INNER JOIN
EliteUser.IET ON EliteUser.IEE.IETID = EliteUser.IET.ID
WHERE ENTRYDATE > '2021-12-31' AND ENTRYDATE < '2023-01-01' AND EliteUser.IET.KIND = 1 AND MARK IS NULL
AND [EliteUser].[COM].[ISACTIVE] = 1
AND IEE.ID NOT IN (SELECT [UDA].[DOMAINID] FROM [EliteUser].[UDA]) -- ΟΡΙΖΟΜΕΝΟΙ ΠΙΝΑΚΕΣ
ORDER BY EliteUser.COM.NAME
Comments
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎