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  -