I have Access tables with Outer Join relationships.
When I run a query using these relationships the SQL generated produces Join statements with Right Outer Joins.
However I get ambigous outer join error messages when I try to run the query.
If I edit the SQL to Left Outer Join the query runs fine.
I do not want to have to edit the SQL every time I use these relationships in my query.
I have read the BO Access user guide and checked the .prm file and every thing seems to be OK.
What can I do to ensure that designer generates the correct Left Join Statement.
When I run a query using these relationships the SQL generated produces Join statements with Right Outer Joins.
However I get ambigous outer join error messages when I try to run the query.
If I edit the SQL to Left Outer Join the query runs fine.
I do not want to have to edit the SQL every time I use these relationships in my query.
I have read the BO Access user guide and checked the .prm file and every thing seems to be OK.
What can I do to ensure that designer generates the correct Left Join Statement.