求一个视图，sql全连接

[孫大聖]

先说下我的需求，
两个表cActual1和cBudget1

cAcutal1
CREATE TABLE [dbo].[cActual1](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Year] [varchar](128) NOT NULL,
	[Month] [int] NOT NULL,
	[Dept] [varchar](128) NOT NULL,
	[Account] [varchar](128) NOT NULL,
	[Actual] [decimal](18, 2) NOT NULL
) ON [PRIMARY]

GO

cBudget1

CREATE TABLE [dbo].[cBudget1](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Year] [varchar](128) NOT NULL,
	[Month] [int] NOT NULL,
	[Dept] [varchar](128) NOT NULL,
	[Account] [varchar](128) NOT NULL,
	[Budget] [decimal](18, 2) NOT NULL
) ON [PRIMARY]

GO

cActual1和cBudget1数据如下


我想要的结果如下，但是一直弄不出来，请各位大神，大哥大姐帮帮忙

[孫大聖]

求大神帮忙啊。

[孫大聖]

大哥大姐们，捧个场啊

[Tiger_Zhao]

    SELECT ISNULL(a.Year,b.Year) Year,
           ISNULL(a.Month,b.Month) Month,
           ISNULL(a.Dept,b.Dept) Dept,
           ISNULL(a.Account,b.Account) Account,
           a.Actual,
           b.Budget
      FROM cActual1 a
 FULL JOIN cBudget1 b
        ON a.Year = b.Year
       AND a.Month = b.Month
       AND a.Dept = b.Dept
       AND a.Account = b.Account

[孫大聖]

引用 3 楼 Tiger_Zhao 的回复:

    SELECT ISNULL(a.Year,b.Year) Year,
           ISNULL(a.Month,b.Month) Month,
           ISNULL(a.Dept,b.Dept) Dept,
           ISNULL(a.Account,b.Account) Account,
           a.Actual,
           b.Budget
      FROM cActual1 a
 FULL JOIN cBudget1 b
        ON a.Year = b.Year
       AND a.Month = b.Month
       AND a.Dept = b.Dept
       AND a.Account = b.Account

我测试下，可以。 谢谢大哥，准备结贴给分。