3
Select one table count(*) from multiple tables MySQL
Select from one table count(*) from two tables MySQL
SELECT *,
(SELECT COUNT(postid) FROM posts where user = 4) AS counter,
(SELECT COUNT(revid) FROM reviews where userid = 4) AS counters
FROM users where usid = 4 LIMIT 1
rated 3 times
(3)
(0)
comments: 0 / hits: 1692
/ 4 years ago, wed, aug 2, 17, 05:43:46
More From
» SQL
Comments
There are no comments for this Snippet yet
Only authorized users can post. Please sign in first, or register a free account