Re: find the number of row for each tables

> Try simply SELECT * from friends;
???
Not working... I just want to know if it's possible to know how many rows
the query return for each table when i do a query with two table ie: select
* from table1, table2 where...

can i know the number of row for table1 and the number of row for table2
without do 2 querys.

thank you
hope to be more clear this time
patrick

> On Tue, 13 Jun 2000, Patrick Coulombe wrote:
>
> > hi,
> > here's the question : if I do this query on my database :
> >
> > SELECT * from friends, strangers WHERE friends.f_id = strangers.s_id AND
> > friends.categorie = 1
> > ----------
> > 88 rows
> >
> > and I need to do this query to know how many rows just for my table
friends
> > (not both table) :
> >
> > SELECT * from friends WHERE friends.f_id = strangers.s_id AND
> > friends.categorie = 1
> > ----------
> > 80 rows
> >
> >
> > Can I just do 1 query and be able to find the number of row for each
tables?
> > Hope to be understand...
> >
> > Patrick