I'm not sure the best way to word this question so bear with me.

Table A has following columns:

• id
• name
• description

Table B has the following columns:

• id
• a_id(foreign key to Table A)
• ip_address
• date

Basically Table B contains a row for each time a user views a row from Table A.

My question is how do I sort Table A results, based on the number of matching rows in Table B.

i.e

SELECT * 
  FROM TableA 
ORDER BY (SELECT COUNT(*) 
            FROM TableB 
           where TableB.a_id = TableA.id)

Thank you!