MySQL Update query with left join and group by - Stack Overflow

I take it that (Index1, Index2) is a unique key on Table , otherwise I would expect the reference to t.

stackoverflow.com