filburt1
03-05-2003, 12:58 AM
SELECT s.title, u.styleid, COUNT(u.styleid) FROM style s, user u WHERE s.styleid = u.styleid GROUP BY u.styleid;
...returns:
+-----------+---------+-------+
| title | styleid | total |
+-----------+---------+-------+
| Default | 1 | 616 |
| New Cubed | 7 | 1 |
+-----------+---------+-------+
2 rows in set (0.01 sec)
However there are five style sets (two of which are invisible). No users are using the "Default vB" style set. So how can I get that to show up in this query?
...returns:
+-----------+---------+-------+
| title | styleid | total |
+-----------+---------+-------+
| Default | 1 | 616 |
| New Cubed | 7 | 1 |
+-----------+---------+-------+
2 rows in set (0.01 sec)
However there are five style sets (two of which are invisible). No users are using the "Default vB" style set. So how can I get that to show up in this query?