Hi,

UPDATED:
I have three tables. I want the SQL Select to include some records from one table, some records from the second table, but only one value from the third table, the most recent date

Here is an example (simplified):
Table1

user_name, user_pk 

So, the above ecords from the Table1 should be in the query
Table2

user_pk, user_email

The column USER_EMAIL from the second table
Table3

user_name, data_in

Date_in - the last time this user logged in.
So the resulting query should look something like this

USER_1     USER_1_EMAIL       USER1_LASTDATE_IN
USER_2     USER_2_EMAIL       USER2_LASTDATE_IN

Here is what I tried

select Table1.USER_NAME as USER_1, MAX(USER_EMAIL) as USER_1_EMAIL, MAX(DATE_IN) AS USER1_LASTDATE_IN FROM Table1
LEFT JOIN Table3 on Table1.USER_NAME = Table3.USER_NAME GROUP BY Table1.USER_NAME 
LEFT JOIN Table2 ON Table2.USER_PK = Table1.USER_PK

The above works.
But I wonder if MAX(USER_EMAIL) will give the correct results. I was hoping that I could select USER_EMAIL from Table2 without MAX.

TIA.