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

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 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

再次感谢。