为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:达梦8
【操作系统】：银河麒麟海光
【CPU】:
【问题描述】*：

SQL需要实现嵌套查询 时间作为查询条件跟子表进行关联查询
下面是MySQL的SQL
SELECT DATE_FORMAT( DATE_ADD( DATE_FORMAT( CURDATE(),‘%Y-%m-%d %H:%i:%s’),INTERVAL (@i:=@i+5) MINUTE ) ,‘%H:%i’) AS time
FROM
(SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9 UNION SELECT 10 UNION SELECT 11 UNION SELECT 12 UNION SELECT 13 UNION SELECT 14 UNION SELECT 15 UNION SELECT 16 UNION SELECT 17 UNION SELECT 18) a,
(SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9 UNION SELECT 10 UNION SELECT 11 UNION SELECT 12 UNION SELECT 13 UNION SELECT 14 UNION SELECT 15 UNION SELECT 16) b,
(SELECT @i:=-5) as i