Patrick Coulombe writes:
> I want to find the number of rows for each table (2) in 1 query,
> the query is:
To find the number of rows in one table you do
SELECT COUNT(*) FROM table;
To find the number of rows in two tables you send two queries like
that. There's no good way to do it in one sh
Hi,
I want to find the number of rows for each table (2) in 1 query,
the query is:
select distinct * from medias, contacts WHERE medias.media_id =
contacts.media_id AND medias_categories.media_id = medias.media_id AND
medias_categories.categorie_id = 1
700 rows
If I want to find the
