added join support for aggregate queries
join support for aggregate queries