simple question

[seahorse123]

I have two tables: tb1, tb2
"tb1" contains fields:
user,
project,
lastupdate

"tb2" contains fields:
user,
profile,
address

"tb1": each user may have multiple projects, with different update time.

Now I want to join this two tables to list all users with profile, address and the latest project update time.

How to write SELECT statement? thanks.

 

[amrita418]

Try this:

select    a.user, 
          a.profile, 
          a.address, 
          b.lastupdate
from      Table2 a,
          (select   user, 
                    max(lastupdate) lastupdate
           from     Table1
           group by user) b
where     a.user = b.user

Regards,
AA

 

[SQLSister]

I'm hoping that user is really userid? If this contains names you could be introuble becasue two people can have the same name and then they would not join correctly.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief