Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- SQL to order records by total number of records

The_Hat - 8:58 pm on Aug 2, 2010 (gmt 0)


Choice A:.. I want to say

name has # total(# in each table)
----------------------
Jack has 11 total (5,3,2,1)
Bob has 9 total (1,4,3,2)
Jan has 7 total (3,2,2,0)
Sue has 5 total (2,1,0,2)

Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4169969.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com