topic Re: Direct Discovery Joins in QlikView https://community.qlik.com/t5/QlikView/Direct-Discovery-Joins/m-p/647414#M437898 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>the best method for Direct Query is to use views.</P><P></P><P>Regards</P><P></P><P>André</P></BODY></HTML> Fri, 31 Oct 2014 15:50:35 GMT agomes1971 2014-10-31T15:50:35Z Direct Discovery Joins https://community.qlik.com/t5/QlikView/Direct-Discovery-Joins/m-p/647413#M437897 <HTML><HEAD></HEAD><BODY><P>To utilize Joins in Direct Query, does the data source always need to be prefixed with ODBC?&nbsp; I am using SQL Server and using OLEDB and unable to make simple joins work.</P><P></P><P>Inaddition, can inner joins, outer joins, left outer joins be used in lieu of just join as provided in the documentation and help example</P></BODY></HTML> Thu, 16 Oct 2014 15:23:52 GMT https://community.qlik.com/t5/QlikView/Direct-Discovery-Joins/m-p/647413#M437897 bjsellers57 2014-10-16T15:23:52Z Re: Direct Discovery Joins https://community.qlik.com/t5/QlikView/Direct-Discovery-Joins/m-p/647414#M437898 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>the best method for Direct Query is to use views.</P><P></P><P>Regards</P><P></P><P>André</P></BODY></HTML> Fri, 31 Oct 2014 15:50:35 GMT https://community.qlik.com/t5/QlikView/Direct-Discovery-Joins/m-p/647414#M437898 agomes1971 2014-10-31T15:50:35Z