I'm an amateur at SQL statements, so I was wondering if
anybody could help me out. I have a database that has a
Tasks table and its primary key is taskId. The database
also has an Updates table and Updates has its primary key
updateId and a foreign key to Tasks called task.
Basically, one task can have many updates. I'm looking
for a query that will select all of the task's columns,
plus the row count of Updates that are associated with
that task. Any help would be greatly appreciated.