Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
the best method for Direct Query is to use views.
Regards
André