|
marcobranco1975
Starting Member
2 Posts |
 Posted - 02/08/2013 : 06:59:11
|
Hi.
i have two tables:
First one: Users with:
id int (primary)
name varchar
and a second user_register with:
id_user
date_usage DateTime
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
Any idea?
Thank's in advance
Marco |
Edited by - marcobranco1975 on 02/08/2013 06:59:48
|
|
Repeated users...
