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

LifeinAsia - 5:16 pm on Jul 15, 2010 (gmt 0)


So you want to
A) count the total number of matching rows across all the linked tables (e.g., 2 for table1 for Bob), or
B) count the number of tables where there are matching rows (e.g., 1 for table1 for Bob)?

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