Show us the statement where you do the count.

--
Aage J.


Walter Neumann wrote:
<<
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?>>