MSQuery error:Cross Join option is not enabled.

B

BAC

I am trying to download data into Excel using MSQuery. I require a LEFT Outer
Join, but that option is greyed out when I double-click the join line and if
i try to type it into the SQL I get the folloewing error message:
**ERROR**(1612) The query requires a cross join, but the cross join option is
not enabled. I could not find this error in the MSQuery help file nor in the
KB.

Nor could I find any meny item that allowed me to set this option.

How do I get the left/right outer joins to work.

XP Pro, MSO 2003

TIA

BAC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

outer join in query 0
Ambiguous outer join 6
A bug in GUI of creating query with more outer joins between two tables 5
msquery: 09815 PRS RCI Result column name must be identifyer 0
MSQuery - Criteria to remove multiple records based on a single re 0
Nested JOIN clauses - order of precedence (Access 2007) 2
msquery in Excel 2007 1
Problem with outer join - Invalid operation (Error 3219) !? 2

Top