67,513
社区成员
发帖
与我相关
我的任务
分享
SELECT AID,a.`NAME`,MAX(CASE Stime WHEN (SELECT STime FROM b WHERE b.AID=c.AID ORDER BY b.Stime LIMIT 0,1) THEN SNAME ELSE NULL END) as SNAME1,
MAX(CASE Stime WHEN (SELECT STime FROM b WHERE b.AID=c.AID ORDER BY b.Stime LIMIT 0,1) THEN Stime ELSE NULL END) as Stime1,
MAX(CASE Stime WHEN (SELECT STime FROM b WHERE b.AID=c.AID ORDER BY b.Stime LIMIT 1,1) THEN SNAME ELSE NULL END) as SNAME2,
MAX(CASE Stime WHEN (SELECT STime FROM b WHERE b.AID=c.AID ORDER BY b.Stime LIMIT 1,1) THEN Stime ELSE NULL END) as Stime2,
MAX(CASE Stime WHEN (SELECT STime FROM b WHERE b.AID=c.AID ORDER BY b.Stime LIMIT 2,1) THEN SNAME ELSE NULL END) as SNAME3,
MAX(CASE Stime WHEN (SELECT STime FROM b WHERE b.AID=c.AID ORDER BY b.Stime LIMIT 2,1) THEN Stime ELSE NULL END) as Stime3,
MAX(CASE Stime WHEN (SELECT STime FROM b WHERE b.AID=c.AID ORDER BY b.Stime LIMIT 3,1) THEN SNAME ELSE NULL END) as SNAME4,
MAX(CASE Stime WHEN (SELECT STime FROM b WHERE b.AID=c.AID ORDER BY b.Stime LIMIT 3,1) THEN Stime ELSE NULL END) as Stime4 FROM b as c
LEFT JOIN a ON c.AID=a.ID
GROUP BY c.AID
运行结果