Posted - 02/08/2013 : 06:59:11
i have two tables:
First one: Users with:
id int (primary)
and a second user_register with:
i need to get the list of users with the last access (not all the access.
i made this
select distinct name, date_usage from users
left join user_register on id_user = id
but i get a all users with all the access register...
i need only one per user with the last login
Thank's in advance
Edited by - marcobranco1975 on 02/08/2013 06:59:48