Re: Retreving count of rows returned by a join query

I know this is an old post that I am responding to, but if you are making these calls from inside of a client application or programming language, often the application or the data structures of the programming language have a count, such as VB’s recordset object has a count() method.

I have a query in which I have joins.

something like

select a.1, b.2 from a, b
where a.3 = b.3;

how can I fetch the number of rows returned by this query.
normal count(*) doesn't work in this context as desired.

Thanks,
~Jas