Hy, I have 2 MySQL tables. Can I make a single Select query to return the total number of rows in the first table ( COUNT(*) ) and the rows (their data) of the seccond table? And if this is posible, how does this query look like?
Hy, For the peoples with the same problem, it is sollved with this code: Code (text): SELECT `useron`.`nume`, `useron`.`sid`, (SELECT count(*) FROM `users`) AS nrusers FROM `useron`