01.06.2015, 11:11
You can only join data from different tables if you have a key to compare with. So no, I don't think that is possible. You can use union to put them beneath each other, but that's about it.
PHP код:
select 'accounts', count(*) from accounts
union
select 'admins', count(*) from accounts where admin > 0
union
select 'vips', count(*) from accounts where vip > 0
union
select 'bans', count(*) from bans