Hi to all,

I have got a little problem with this query:
SELECT
n.*, (n.datefinish-CURRENT_TIMESTAMP)*{DAY} rest, n.article,
n.idealprice, c.name,
(SELECT COUNT(*) FROM offers o WHERE o.nbid=n.id) offers
FROM need n, category c
WHERE
c.id=n.catid AND c.isactive=1 AND n.userid=? AND
CURRENT_TIMESTAMP>=n.datestart
AND CURRENT_TIMESTAMP<=n.datefinish
ORDER BY offers;

and getting Dynamic SQL Error SQL error code = -206 Column unknown OFFERS.
Is it possible to %subj%?

thanx
Michal