mysql计数记录来自两个表的一个查询?

I have three MySQL-tables:

我有三个mysql表:

patient:
    paID, paCode, paAccountID (foreign key)

test
    tsID, tsName, tsPatientID (foreign key), tsAccountID (foreign key)

account
    acID etc.
pati