[Solved] How would I right a select statement to query this database?

by


Try joining between client and test table like:

SELECT c.forename, COUNT(c.forname)
FROM Client c INNER JOIN Test t
ON c.clientNo = t.clientNo
WHERE c.forename="Jim"
AND   t.status="PASS"
GROUP BY c.forname

2

solved How would I right a select statement to query this database?