|
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? |
|