“b on a.something = a.something” produce an error.
a.something=b.something !!! another option: select a.someting, a.anotherthing, b.total >from first a inner join ( select someting,sum(thirdhing) as total >from second group by someting having sum(thirdhing)>10 ) b on >a.someting=b.someting
