Subselect in SELECT

From: Matthias Matker <kernkoenig_at_arcor.de>
Date: Sat, 20 Jan 2007 17:12:52 +0100
Message-ID: <45b23f83$0$27614$9b4e6d93@newsspool2.arcor-online.net>

Hello together,

SELECT

     persons.name
     ( SELECT COUNT(*) amount FROM person_cds WHERE ( person_cds.pname= persons.name))
FROM
     persons

WHERE ( amount< 280)
ORDER by persons.name;
EXIT; I want the name of the persons ( name is primary key of persons), which have fewer cds than 280.

After executing this query, I got the Message,

"amount" invalied identifier.

Can you explain me, why?

Thanks Received on Sat Jan 20 2007 - 10:12:52 CST