To utilize Joins in Direct Query, does the data source always need to be prefixed with ODBC? I am using SQL Server and using OLEDB and unable to make simple joins work.
Inaddition, can inner joins, outer joins, left outer joins be used in lieu of just join as provided in the documentation and help example
