Add select without it being listed

I have the following that works just fine:

Select t1.idemployer as idemp,, 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.