I'm hope somebody can help me get unstuck here - I'm trying to use an aggregate function in a select statement but it appears that you can't use one as a column -
SELECT number, name, (SELECT COUNT(*) FROM pet WHERE employee.number = pet.number) AS pets FROM employee I can't come up with another way of doing this, or working out what I'm doing wrong. Cheers, James