История изменений

Исправление bvn13, 25.10.16 16:00 (текущая версия) :

SELECT a.time AS start, MINIMUM(b.time) AS fin
FROM a AS a
LEFT JOIN b AS b
ON a.time <= b.time

если что, гуглить на тему: срез последних в запросе sql

Исправление bvn13, 25.10.16 15:59:

SELECT a.time AS start, MINIMUM(b.time) AS fin
FROM a AS a
LEFT JOIN b AS b
ON a.time <= b.time

Исходная версия bvn13, 25.10.16 15:59:

SELECT a.time AS start, MINIMUM(b.time) AS fin
FROM a AS a
LEFT JOIN b AS b
ON a.time <= b.time