[MSAccessProfessionals] Access Data Query long running - left join

I am trying to fetch data from two tables of 0.7 M records Left Join match all 7 columns with 1.5 M records table and Group By all columns from left table. 

Data Query is getting freezed and long running with no output. FYI i tried applying index

I am getting immediate output if i use aggregate functions with this join 

Please advise at the earliest