SQLTeam.com | Weblogs | Forums

Add select without it being listed


#1

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