Quote:
Originally posted by Halx
Assuming everyone votes.. this is how it will end up:
Code:
mysql> SELECT S.title, COUNT(*)
FROM user U, style S
WHERE U.styleid = S.styleid
GROUP BY U.styleid;
+------------+----------+
| title | COUNT(*) |
+------------+----------+
| TFP v4.0 | 26528 |
| Dark Cloud | 373 |
| Sandstorm | 190 |
+------------+----------+
3 rows in set (0.23 sec)
|
__________________
SWM, tattooed, seeks meaningful tits and beer. Enjoys biker mags, pornography, and Sunday morning walks to the liquor store. Winners of erotic hot dog eating contests given priority.
Last edited by Midnight_Son; 08-28-2003 at 11:27 AM..
|