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.