请教各位大神，求个SQL查询

Question

一个表A
Index,Quality,Value,Time
1,192,0,2016-12-16 00:00:00
1,84,1,2016-12-16 00:01:00
1,84,2,2016-12-16 00:02:00
1,84,3,2016-12-16 00:03:00
1,192,4,2016-12-16 00:04:00
1,192,5,2016-12-16 00:05:00
1,84,6,2016-12-16 00:06:00
1,84,7,2016-12-16 00:07:00
1,84,8,2016-12-16 00:08:00
1,192,9,2016-12-16 00:09:00
1,84,10,2016-12-16 00:10:00
1,192,11,2016-12-16 00:11:00

另一个表B
Index,Name
1,TestName

现在要查询一个结果:
Index,Name,Value,Quality,StartTime,EndTime
1,TestName,1,84,2016-12-16 00:01:00,2016-12-16 00:04:00
1,TestName,2,84,2016-12-16 00:02:00,2016-12-16 00:04:00
1,TestName,3,84,2016-12-16 00:03:00,2016-12-16 00:04:00
1,TestName,6,84,2016-12-16 00:06:00,2016-12-16 00:09:00
1,TestName,7,84,2016-12-16 00:07:00,2016-12-17 00:09:00
1,TestName,8,84,2016-12-16 00:08:00,2016-12-16 00:09:00
1,TestName,10,84,2016-12-16 00:10:00,2016-12-16 00:11:00

简单解释就是查找Quality不是192的数据,并记录该条数据的Time为StartTime, 然后查找这条数据的Time之后第一条Quality为192的数据，并记录该条的Time为EndTime

Answer 1

SELECT a.Index,b.Name,a.Value,a.Quality,a.time AS StartTime,(SELECT a2.time FROM A a2 WHERE a2.time > a.time ORDER BY a2.time ASC LIMIT 1) AS EndTime FROM A a LEFT JOIN B b ON a.index = b.index WHERE a.Quality != 192