>I am using SPT to get remote data from two tables.
>
>One table(Task Table) has a field called schuledhours. The second table(Assignments Table) is a child of table one with a field called assignedhours. I need a sql that lists the scheduledhours, sum of assignedhours.

	SELECT scheduledHours, SUM(assignedhours) 
		FROM tasks LEFT JOIN assignments ON pk = fk 
		GROUP BY scheduledHours

hth
-Stefan