select - MySQL: Count() Subquery returns nothing -


i want count user id's , entries in table country. when execute query doesn't display result.

select (   select     count(userid)       tbl_user )   countuser, (   select     country       tbl_user )   country 

i appreciate every , comment!

use below query

select (select count(userid) tbl_user) usercount ,  userid, country tbl_user 

Comments