Thread: Access SQL Full Outer Join Into Different Table

Hi

I am trying to modifiy my SQL to go from only combining two tables to combining three or more. My code for two tables, which worked great, was:

Code:

CurrentDb.QueryDefs("qry_Fields_Used_By_Innovient").SQL = "SELECT " & strFields & "INTO tbl_All_Fields_For_Innovient FROM " & strSourceTables & " WHERE " & strSourceTablesLinkFields & ";"

Now that I am using three or more tables, I believe I need to switch to a FULL OUTER JOIN. Below is what I think it should be, but the error that comes up says my syntax is incorrect in the WHERE clause:

Code:

CurrentDb.QueryDefs("qry_Fields_Used_By_Innovient").SQL = "SELECT " & strFields & " FROM " & strSourceTables & " FULL OUTER JOIN tbl_All_Fields_For_Innovient ON " & strSourceTablesLinkFields & ";"

Any suggestions?

Thanks