求助(急) 执行全外连接查询引发的错误

xhcb

SELECT a.*,b.*
FROM sheet1 as a FULL OUTER JOIN sheet2 as b ON a.f3=b.f3;

执行以上语句会提示FROM 子句语法错误,为什么?请高手指教.

xhcb

再次感谢。

nxjswt

SELECT Sheet1.F1, Sheet1.F2, Sheet2.F1, Sheet2.F2, Sheet2.F3
FROM Sheet2 RIGHT JOIN Sheet1 ON Sheet2.F3=Sheet1.F3
ORDER BY Sheet2.F3 DESC;
UNION SELECT Sheet1.F1, Sheet1.F2, Sheet2.F1, Sheet2.F2, Sheet2.F3
FROM Sheet2 LEFT JOIN Sheet1 ON Sheet2.F3=Sheet1.F3
ORDER BY Sheet2.F3 DESC;

xhcb

谢了，终于搞定。

可是结果中有些重复项，怎么去除重复项呢？

[此贴子已经被作者于2006-6-4 22:14:51编辑过]

nxjswt

SELECT Sheet1.F1, Sheet1.F2, Sheet2.F1, Sheet2.F2, Sheet2.F3
FROM Sheet2 RIGHT JOIN Sheet1 ON Sheet2.F3=Sheet1.F3
ORDER BY Sheet2.F3 DESC;
UNION ALL
SELECT Sheet1.F1, Sheet1.F2, Sheet2.F1, Sheet2.F2, Sheet2.F3
FROM Sheet2 LEFT JOIN Sheet1 ON Sheet2.F3=Sheet1.F3
ORDER BY Sheet2.F3 DESC;

xhcb

SELECT sheet1.*, sheet2.*
FROM sheet1 LEFT JOIN sheet2
ON sheet1.f3 = sheet2.f3
UNION ALL SELECT sheet1.*, sheet2.*
FROM sheet1 RIGHT JOIN sheet2
ON sheet1.f3 = sheet2.f3
WHERE sheet1.f3 IS NULL;


这样行不行？

xhcb

是以F3为连接条件的对应查询，有什么办法可以让对应到的依次排列，对不上的接在后面也一个不漏吗？

类型对不上的可以修改

[此贴子已经被作者于2006-6-4 21:35:01编辑过]

nxjswt

1、你的EXCEL2最后显示第二列类型不符合，521-524

2、你的目的是重复查询还是必须对应查询啊

[此贴子已经被作者于2006-6-4 21:22:56编辑过]

xhcb

好象这是右外连接，这样得到的结果也不会全的,有部分存在SHEET1而不在SHEET2的记录就会丢失。

xhcb

EXCEL中的SHEET1、SHEET2