Re: Retreving count of rows returned by a join query

On Thursday 31 May 2007 05:17, Jasbinder Singh Bali wrote:
> with count(*) i want other  rows as well
> something like
>
> select count(*) , a.3 from a, b where a.3 = b.3;

That would require two queries unless you want to use subqueries:

select count(*) from a,b where a.3=b.3;

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

Sean