SELECT gongid ,
(SELECT COUNT(cdt)FROM kqj ) AS cdc,
(SELECT COUNT(ztt) FROM kqj ) AS ztc,
(SELECT sum(jbs) FROM jb ) AS jbs
FROM workerinfo;我想在SQL语句中同时把cdc,ztc相加怎么办?
(SELECT COUNT(cdt)FROM kqj ) AS cdc,
(SELECT COUNT(ztt) FROM kqj ) AS ztc,
(SELECT sum(jbs) FROM jb ) AS jbs
FROM workerinfo;我想在SQL语句中同时把cdc,ztc相加怎么办?
SELECT gongid ,
(SELECT COUNT(cdt)FROM kqj ) AS cdc,
(SELECT COUNT(ztt) FROM kqj ) AS ztc,
(SELECT sum(jbs) FROM jb ) AS jbs
FROM workerinfo;
) as t