Tag Archives: SQL

Microsoft Access is confused

The other day while working on a legacy Microsoft Access database I was reminded of how bizarre Access can be. When I ran the following query:

I received a peculiar error:

Microsoft Access
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.

For a query with no outer joins, this was terribly unhelpful.
Continue reading