I have the following that works just fine:
Select t1.idemployer as idemp, t1.name, t2.totaljobs from SCHOOL t1 LEFT JOIN (select idemployer, count(idemployer) as totaljobs from JOB Group by idemployer) t2 ON t1.idemployer = t2.idemployer
However, I would like to add the JOB table to the above and retrieve data ONLY ON DEMAND "Group by idemployer". I do not wish the data from JOB to be be listed.
Thanks