Re: find the number of row for each tables

Try simply SELECT * from friends;


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
> 
> 
> 
> 

Yours Truly,

  	 - Karl F. Larsen, k5di@arrl.net  (505) 524-3303  -