Hello,

I am a beginner user of Microsoft Access. Also, I do not know SQL.

When trying to run my Access Query I receive the following error message:

“The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement.”

Can you please tell me how to resolve this issue, and if there is a You Tube video to help me with this solution?

Thank you for the help!

JeffL1961

​Hello,I am a beginner user of Microsoft Access. Also, I do not know SQL. When trying to run my Access Query I receive the following error message: “The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement.” Can you please tell me how to resolve this issue, and if there is a You Tube video to help me with this solution? Thank you for the help! JeffL1961  Read More

​