Subquery help needed

polina

Registered User.
Local time
Today, 04:01
Joined
Aug 21, 2002
Messages
100
Hi,

I was wondering if I could do something like follwing and what is the right syntax for that

Select COUNT ( select fld1, fld2, fld3, fld4, fld5 from query1)

I know I could create another query and say SELECT COUNT(*) from query1

But I need to count it in one query

Thanks.
 

Users who are viewing this thread

Back
Top Bottom