Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Selecting records where joining table has most records
Hi, I have the two tables below... Table_1 ------- id user_id Table_2 ------- id table_1_id Table_1 can have many of Table_2 and I need to retrieve one Table_1 record which has the most Table_2 records. This is for a recommendation engine. Thanks in advance guys :)
