求一SQL - .NET技术 / C#

现有两个表

  表1 user (用户信息 )  

  username password  
  A 123  
  B 000
  C 555




表2 record (用户记录)
  id username logintime
  1 C 2009-10-10
  2 A 2009-10-11
  3 A 2009-10-12
  4 B 2009-10-13
  5 B 2009-10-15
  6 C 2009-10-16


表2 id列是自动编号，recordtime是最后登陆时间时间，现在要显示表1的所有信息 及最后记录时间,结果应该如下

username password logintime
A 123 2009-10-12
B 000 2009-10-15
C 555 2009-10-16

请问这条SQL语句如何写



   

---

我还在学，等我学会了教你啊，嘎嘎...

---

select username,password,(select top 1 logintime from record where record.username=[user].username order by logintime desc ) from [user] 

---

select a.*,b.lasttime from user as a 
left join
(select max(logintime)as lasttime,username from record group by username)
as b
on a.username = b.username

---

select t1.*,t2.lasttime from user t1 
left join
(select username,max(logintime)as lasttime from record g