SQL query problem

laoleng

I now use this statement to query a recordset,
select a. * from tablename a where datetimecolumn = (select max (datetimecolumn) from tablename where username = a.username)

Then I have to do a join condition with a table called erid. In the query result, username = erid.username
After I tried to do jion directly, I still only get the results of the previous query. Everything in the erid table comes out. Isn't it written like this? How to write it?

trampzz

Is this right?
select a. *, e. * from tablename a
join erid e on e.username = erid.username
where a.datetimecolumn = (select max (datetimecolumn) from tablename where username = a.username)

yaeric

select a. *, e. * from tablename a
right join erid e on e.username = erid.username
where a.datetimecolumn = (select max (datetimecolumn) from tablename where username = a.username)
?

karaoke520

select a.*,b.* from tablename a
right join erid b on a.username=b.username
where a.datetimecolumn=(select max(datetimecolumn) from tablename where username=a.username)