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