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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Quantum3k

  1. Quantum3k

    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 :)

Part and Inventory Search

Back
Top