select A.* from A,B where A.id=B.id and B.UpdateTime=(select max(B.UpdateTime)from A,B where B.id="4443" )
select a.*,b.* from a,b as b1 where a.id= b.id not exists (select 1 from b where b.时间字段> b1.时间字段)
hu0516(专业接分) Thank you 你的回复可以查到某一条记录 如果我想得到所有员工的 列表呢?
select top 1 A.*,B.* FROM A,B where A.AutoId = B.PersonId order by B.迟到时间 desc
hu0516(专业接分) Thank you 你的回复可以查到某一条记录 如果我想得到所有员工的 列表呢?select A.*,B.* FROM A,B where A.AutoId = B.PersonId
QQMagicer(在IT的路上越走越远), showrock(玉蝴蝶) 谢谢!!
如果你的UpdateTime的值没有重复值,这样就可以了 select A.*,b.* from A,B where A.id=B.id and B.UpdateTime in(select max(B.UpdateTime),B.id from B group by B.id)
select aa.*,bb.* from A aa left join B bb on bb.PersonId=aa.AutoId and bb.AutoId=(select top 1 AutoId From B where PersonId=bb.PersonId order by UpdateTime desc)
问题已经解决了. SELECT * FROM A INNER JOIN (SELECT B.PersonId,MAX(迟到时间) AS TIME FROM B GROUP BY B.PersonId) AS P ON A.AutoId = P.PersonId
select A.* from A,B where A.id=B.id and A.UpdateTime=B.UpdateTime
对 mapserver(杨东 http://mapserver.cnblogs.com) 表示感谢.
from a,b as b1
where a.id= b.id
not exists (select 1 from b where b.时间字段> b1.时间字段)
你的回复可以查到某一条记录 如果我想得到所有员工的 列表呢?
你的回复可以查到某一条记录 如果我想得到所有员工的 列表呢?select A.*,B.* FROM A,B where A.AutoId = B.PersonId
select A.*,b.* from A,B where A.id=B.id and B.UpdateTime in(select max(B.UpdateTime),B.id from B group by B.id)
SELECT * FROM A INNER JOIN (SELECT B.PersonId,MAX(迟到时间) AS TIME FROM B GROUP BY B.PersonId) AS P ON A.AutoId = P.PersonId