The SELECT statement syntax of Access and SQL Server are different, but you can still do a full outer join in both using the older syntax where you separate the table names with commas and do not specify any join criteria: "select c.*, o.* from Customers as c, Orders as o" for example.