22,206
社区成员
发帖
与我相关
我的任务
分享
SELECT a1.id, a1.cname, a1.depid, a1.userid, a2.ptime, a3.gtime FROM a1 LEFT OUTER JOIN a2 ON a1.id = a2.compid LEFT OUTER JOIN a3 ON a1.id = a3.compid WHERE (c.depid = 18)
SELECT a1.id, a1.cname, a1.depid, a1.userid, a2.ptime, a3.gtime
FROM a1
LEFT OUTER JOIN a2
ON (a1.id = a2.compid
and not exists(select 1 from a2 a where a2.cid=a.cid and a2.ptime<a.ptime))
LEFT OUTER JOIN a3
ON (a1.id = a3.compid
and not exists(select 1 from a3 b where a3.cid=b.cid and a3.gtime<b.gtime ))
WHERE c.depid = 18
SELECT a1.id, a1.cname, a1.depid, a1.userid, a2.ptime, a3.gtime FROM a1 LEFT OUTER JOIN a2 ON a1.id = a2.compid and not exists (select 1 from a2 aa2 where aa2.compid=a2.compid and aa2.ptime>a2.ptime) LEFT OUTER JOIN a3 ON a1.id = a3.compid and not exists (select 1 from a3 aa3 where aa3.compid=a3.compid and aa3.gtime>a3.gtime) WHERE (a1.depid = 18)
SELECT a1.id, a1.cname, a1.depid, a1.userid, a2.ptime, a3.gtime
FROM a1
LEFT OUTER JOIN a2 ON a1.id = a2.compid
LEFT OUTER JOIN a3 ON a1.id = a3.compid
WHERE (c.depid = 18
and not exists(select 1 from a2 a where a2.cid=a.cid and a2.ptime<a.ptime)
and not exists(select 1 from a3 b where a3.cid=b.cid and a3.gtime<b.gtime )
)