在delphi中如何把两个表链接起来？

[linlingwei]

有access两个表
ck表和jk表

ck表：
id ck_num
001 20
001 10
003 25

jk表：
id jk_num
001 50
002 40
002 5

如何让其显示为：
id ck_num jk_num
001 30 50
002 0 45
003 25 0
这个查询语句应该怎么写呢？
研究了两天，还是没做出来。大侠帮帮忙

[bdmh]

select a.id,a.ck_num,b.jk_num from ck as a inner join jk as b on a.id=b.id

[linlingwei]

to bdmh：
两个表都用到 sum（）和group by，你的语句不行呀

[kenlewis]

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

[kenlewis]

上面那个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

[kenlewis]

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

[kaikai_kk]

楼上的可行,不过要用union all,而不是union