访问 SQL 全外连接 [英] Access SQL Full Outer Join

问题描述

我试图在访问时完全外部连接两个表，因为我想保留所有项目.

Hi I was trying to Full Outer join two tables on access because I want to keep all items.

这是我的代码:

    SELECT aa.*, bb.firstname, bb.lastname, bb.totalcost
    FROM (select IT.*,HR.*from IT
    left join HR on HR.firstname=it.firstname and HR.lastname=IT.lastname)  
    AS 
    aa FULL OUTER JOIN 2016totalcost AS bb ON (bb.lastname=aa.IT.lastname) 
    AND (bb.firstname=aa.IT.firstname);

但是我在 from 子句中遇到了语法错误

But I got error syntax error in from clause

感谢帮助

推荐答案

注意:当我回答时，问题被标记为 Oracle.

NOTE: The question was tagged Oracle when I answered.

Oracle 语法为:

The Oracle syntax would be:

select IT.*, HR.*, bb.firstname, bb.lastname, bb.totalcost
from IT left join
     HR
     on HR.firstname = it.firstname and HR.lastname = IT.lastname full outer join 
     2016totalcost tc 
     on tc.lastname = it.lastname and tc.firstname = it.firstname;

这篇关于访问 SQL 全外连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！