This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
The Microsoft query does not let me specify any other types of Joins except for Inner Joins. The other joins types are grayed out, and I need Left Join ( In Microsoft query it is the second option). I don't understand why the other join types are grayed out - and how can I get them to work.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Well this is probably not the problem but in the Joins dialog box there is a Operator choice at the top, if that is anything other than = outer joins will not be available.
If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire