MS Access Full Outer Join Issue

Question

I understand that MS Access does not 'Full Outer Join' function. I would like to combine two database into 1 big database.

An example is as follow:

In conclusion, I would like to have full outer join to combine all columns from two database into 1 big database. Please advise alternative for full outer join in Access.

Answer 1

Try this

SQL Fiddle

select column1a,column2,coulmn3,column4,columna,'' as columnb from table1
union all 
select column1b,column2,coulmn3,column4,'' as columna,columnb from table2

Answer 2

You don't want a FULL OUTER JOIN, you want a UNION.

SELECT Column1A as Column1, Column2, Column3, Column4, ColumnA, NULL AS ColumnB
FROM Table1
UNION ALL
SELECT Column1B, Column2, Column3, Column4, NULL, ColumnB
FROM Table2;