Třídová akce

Kód:

4

Tělo:

Select
  B.PersonalNumber as MaxCode,
  B.ID as ID,
  B.LastName as Name,
  B.Hidden as Hidden
from
  Persons B
where
  B.PersonalNumber = (SELECT MAX(PersonalNumber) 
                      FROM Employees A, Persons B 
                      WHERE (PersonalNumber LIKE :Formula) AND (A.Person_ID = B.ID))
/* puvodni:
SELECT MAX(PersonalNumber) AS MaxCode FROM Employees A, Persons B
WHERE
 (PersonalNumber LIKE :Formula) AND
 (A.Person_ID = B.ID)
*/

Generated by ABRA Software a.s. 27.10.2021 16:34:35