CREATE TABLE #T (userid int, username varchar(100), memo varchar(100)) Insert #t (userid, username) Select userid, username from 表a Select userid, Max(edate) as edate, memo into #t1 From 表b group by userid, memo Update #t Set memo = a.memo From #t1 a, #t b where a.userid = b.userid Select * From #t Drop table #t, #t1
select a.userid, a.username, memo from 主表a a, (Select userid, Max(edate) as edate, memo 子表b group by userid, memo) b where a.userid = b.userid
我没装SQL不以测试,你式一下。 select a.userid, a.username, b.memo from 主表a a, (Select userid, Max(edate) as edate, memo 子表b group by userid, memo) b where a.userid = b.userid
我试了一下不行啊! select a.userid, a.username, b.memo from 主表a a, (Select userid, Max(edate) as edate, memo 子表b <<<<这里是不是有from>>> group by userid, memo) b where a.userid = b.userid
select a.userid,a.username,b.memo from 主表a a,子表b b where a.userid = b.userid order by edate desc
select a.userid, a.username, b.memo from 主表a a, (Select userid, Max(edate) as edate, memo from 子表b group by userid, memo) b where a.userid = b.userid
sankis() 你好,你的这个回答我试过了不行啊你可以可以再看一看
select a.userid,username,edate,meno from a,b where a.userid=b.userid and edate in ( select max(edate) from b group by userid having count(*)>1 )
select a.userid,a.username,b.memo from 表a a,表b b where a.userid = b.userid and b.edate = (select max(c.edate) from 表b c where a.userid = c.userid)
在关键字 'top' 附近有语法错误。
Insert #t (userid, username) Select userid, username from 表a
Select userid, Max(edate) as edate, memo into #t1 From 表b group by userid, memo
Update #t Set memo = a.memo From #t1 a, #t b where a.userid = b.userid
Select * From #t
Drop table #t, #t1
where a.userid = b.userid
select a.userid, a.username, b.memo from 主表a a, (Select userid, Max(edate) as edate, memo 子表b group by userid, memo) b
where a.userid = b.userid
select a.userid, a.username, b.memo from 主表a a, (Select userid, Max(edate) as edate, memo 子表b <<<<这里是不是有from>>> group by userid, memo) b
where a.userid = b.userid
where a.userid = b.userid
from a,b
where a.userid=b.userid and edate in
(
select max(edate) from b group by userid having count(*)>1
)
b.edate = (select max(c.edate) from 表b c where a.userid = c.userid)