select user.name as p_name,client.name as c_name,max(login.date) as Mdate from login,user,client where login.id = user.id, user.id = client.id, login.id = client.id order by p_name asc

有木有老铁们 帮忙看看这个答案为啥不对？