find the number of row for each tables

Patrick Coulombe <11h11@videotron.ca>

From: Patrick Coulombe <11h11@videotron.ca>
To: pgsql-novice@postgresql.org
Date: 2000-06-14T03:01:18Z
Lists: pgsql-novice
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