做echart的图形接口,需要将不同的表联合查询,并且在一个接口中返回。
SELECT SUM(f_jfje) AS VALUE,'年检' AS NAME FROM F_NJDJ
UNION ALL
SELECT SUM(f_zfy) AS VALUE,'维保' AS NAME FROM F_WBQC
UNION ALL
SELECT SUM(F_BXFY) AS VALUE,'保险' AS NAME FROM F_BXDJ
返回结果
做echart的图形接口,需要将不同的表联合查询,并且在一个接口中返回。
SELECT SUM(f_jfje) AS VALUE,'年检' AS NAME FROM F_NJDJ
UNION ALL
SELECT SUM(f_zfy) AS VALUE,'维保' AS NAME FROM F_WBQC
UNION ALL
SELECT SUM(F_BXFY) AS VALUE,'保险' AS NAME FROM F_BXDJ
返回结果