Joining tables together in a model function

[eluser]Jaketoolson[/eluser]
SELECT *.c FROM ctiteria.c
INNER JOIN tasks t ON t.task_id=c.task_id
INNER JOIN data d ON d.criteria_id=c.criteria_id
WHERE c.task_id = x
AND d.task_id = y
HAVING COUNT(d.qms_id) > 0

gets all from criteria table innerjoins on tasks and data when there are more than 0 results found from table data on qms