mysql中union与join_如何在mysql中使用join和union进行子查询

我试图在两个子查询中使用连接和联合 . 这是我的查询：

SELECT Service,SP.Second_Period, SP.TRX_SP,FP.First_Period,FP.TRX_FP

FROM (((SELECT Service, SUM(Processed) as Second_Period, COUNT(Processed) as TRX_SP

FROM pay

WHERE Status1='Processed' AND Dataime BETWEEN '2017-05-07 00:00:00' and '2017-05-14 00:00:00'

GROUP BY Service) SP

RIGHT JOIN

(SELECT Service, SUM(Processed) as First_Period, COUNT(Processed) as TRX_FP

FROM pay

WHERE Status1='Processed' AND Dataime BETWEEN '2017-05-01 00:00:00' and '2017-05-06 00:00:00'

GROUP BY Service) FP USING (Service))

UNION ALL

((SELECT Service, SUM(Processed) as Second_Period, COUNT(Processed) as TRX_SP

FROM pay

WHERE Status1='Processed' AND Dataime BETWEEN '2017-05-07 00:00:00' and '2017-05-14 00:00:00'

GROUP BY Service) SP

LEFT OUTER JOIN

(SELECT Service, SUM(Processed) as First_Period, COUNT(Processed) as TRX_FP

FROM pay

WHERE Status1='Processed' AND Dataime BETWEEN '2017-05-01 00:00:00' and '2017-05-06 00:00:00'

GROUP BY Service) FP USING (Service) )) as tbl2

WHERE SP.Service=FP.Service

GROUP BY Service

Order BY Service

通过这样做它返回给我这个错误：

1064 - 您的SQL语法出错;检查与MariaDB服务器版本对应的手册，以便在'LEFT OUTER JOIN附近使用正确的语法(SELECT服务，SUM(已处理)为First_Period，COUNT(第16行处理')

我究竟做错了什么？因为我不能在mysql中使用Full Outer Join，所以我正在使用左和右连接 .

UPDATE

这是使用DAYNAME(Dataime)替换服务的ny代码

SELECT *

FROM (

(

SELECT * FROM

(SELECT DAYNAME(Dataime), SUM(Processed) as Second_Period, COUNT(Processed) as TRX_SP

FROM pay

WHERE Status1='Processed' AND Dataime BETWEEN '2017-05-07 00:00:00' and '2017-05-14 00:00:00'

GROUP BY DAYNAME(Dataime)) SP

RIGHT JOIN

(SELECT DAYNAME(Dataime), SUM(Processed) as First_Period, COUNT(Processed) as TRX_FP

FROM pay

WHERE Status1='Processed' AND Dataime BETWEEN '2017-05-01 00:00:00' and '2017-05-06 00:00:00'

GROUP BY DAYNAME(Dataime)) FP USING (DAYNAME(Dataime)))

UNION ALL

(

SELECT * FROM

(SELECT DAYNAME(Dataime), SUM(Processed) as Second_Period, COUNT(Processed) as TRX_SP

FROM pay

WHERE Status1='Processed' AND Dataime BETWEEN '2017-05-07 00:00:00' and '2017-05-14 00:00:00'

GROUP BY DAYNAME(Dataime)) SP

LEFT OUTER JOIN

(SELECT DAYNAME(Dataime), SUM(Processed) as First_Period, COUNT(Processed) as TRX_FP

FROM pay

WHERE Status1='Processed' AND Dataime BETWEEN '2017-05-01 00:00:00' and '2017-05-06 00:00:00'

GROUP BY DAYNAME(Dataime)) FP USING (DAYNAME(Dataime)) )) as tbl2

GROUP BY DAYNAME(Dataime)

Order BY DAYNAME(Dataime)

这是错误：

1064 - 您的SQL语法出错;检查与您的MariaDB服务器版本对应的手册，以便在'(Dataime)附近使用正确的语法))UNION ALL(