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(at)arrl(dot)net (505) 524-3303 -