Re: why must i specify an index in query?

[Peter Brawley]

> The purpose of the query is to pull all the users and join their last page accessed.

If that's correct, the Left Join is senseless since obviously, if the user has any userhits rows, she has a last one, so the query would be ...

select u.*, t.id  
from usersmobile u
join (
  select userid2, max(id) as lastID
  from userhits
  group by userid2
) t on u.id=t.userid2;

and you can if desired add a second join to userhits to get detail userhits cols ....

join userhits d on t.lastID=d.id



Or do you mean: pull all the users and join their last page accessed if any? In that case, you're stuck wit the left join.