select a.id,a.ck_num,b.jk_num from ck as a inner join jk as b on a.id=b.id
to bdmh: 两个表都用到 sum()和group by,你的语句不行呀
SELECT id, ck_num, jk_num FROM ( SELECT id, ck_num, 0 AS jk_num FROM ck UNION SELECT id, 0 AS ck_num, jk_num FROM jk ) A
上面那个SQL语句写错了。这个才对。 SELECT id, SUM(ck_num) AS ck_num, SUM(jk_num) AS jk_num FROM ( SELECT id, ck_num, 0 AS jk_num FROM ck UNION SELECT id, 0 AS ck_num, jk_num FROM jk ) A GROUP BY id
SELECT id, SUM(ck_num) AS ck_num, SUM(jk_num) AS jk_num FROM ( SELECT id, ck_num, 0 AS jk_num FROM ck UNION SELECT id, 0 AS ck_num, jk_num FROM jk ) A GROUP BY id
两个表都用到 sum()和group by,你的语句不行呀
id,
ck_num,
jk_num
FROM
(
SELECT
id,
ck_num,
0 AS jk_num
FROM ck
UNION
SELECT
id,
0 AS ck_num,
jk_num
FROM jk
) A
SELECT
id,
SUM(ck_num) AS ck_num,
SUM(jk_num) AS jk_num
FROM
(
SELECT
id,
ck_num,
0 AS jk_num
FROM ck
UNION
SELECT
id,
0 AS ck_num,
jk_num
FROM jk
) A
GROUP BY id
SELECT
id,
SUM(ck_num) AS ck_num,
SUM(jk_num) AS jk_num
FROM
(
SELECT
id,
ck_num,
0 AS jk_num
FROM ck
UNION
SELECT
id,
0 AS ck_num,
jk_num
FROM jk
) A
GROUP BY id