Hi All,
could anyone help me with this select statement? I use Firebird 1.0.0 SS on
Linux:
SELECT MA.PERSONENIDINT, MA.NN, MA.VN, MA.TITEL FROM MITARBVIEW MA
WHERE 'TODAY' >= (SELECT MAX(EA.EINTRITTSDATUM) FROM MITARBEINAUSVIEW EA
WHERE ((EA.MITARBID = MA.PERSONENIDINT)
AND ((EA.AUSTRITTSDATUM IS NULL) OR (EA.AUSTRITTSDATUM >= 'TODAY'))))
ORDER BY MA.NN, MA.VN;

Executing this select runs ok. Then I try a record count and receive the error
Column unknown MA.PERSONENIDINT. Why? This column exists really.
Any idea?
Thank you!