topic Re: custom SQL join in qlikview in QlikView https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53268#M782706 <HTML><HEAD></HEAD><BODY><P>yes I'm getting an error. so can you please help me the exact syntax in qlikview to join two tables in custom sql </P></BODY></HTML> Tue, 20 Mar 2018 07:04:14 GMT manoj217 2018-03-20T07:04:14Z custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53266#M782704 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to join two tables in custom SQL In Qlikview , can anyone please help me how to join two tables and I don't want the preceding load, I want only custom SQL.</P><P></P><P>My data Base is Oracle not a SQL is it possible to do Custom sql in Qlikview.</P><P></P><P>Thanks,</P><P>Manoj </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53266#M782704 manoj217 2020-11-25T16:16:04Z Re: custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53267#M782705 <HTML><HEAD></HEAD><BODY><P>You can directly write the query in script editor.</P><P>Are you getting any error?</P></BODY></HTML> Tue, 20 Mar 2018 07:01:40 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53267#M782705 shiveshsingh 2018-03-20T07:01:40Z Re: custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53268#M782706 <HTML><HEAD></HEAD><BODY><P>yes I'm getting an error. so can you please help me the exact syntax in qlikview to join two tables in custom sql </P></BODY></HTML> Tue, 20 Mar 2018 07:04:14 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53268#M782706 manoj217 2018-03-20T07:04:14Z Re: custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53269#M782707 <HTML><HEAD></HEAD><BODY><P>Share me the query, what error are you getting?</P></BODY></HTML> Tue, 20 Mar 2018 07:11:10 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53269#M782707 shiveshsingh 2018-03-20T07:11:10Z Re: custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53270#M782708 <HTML><HEAD></HEAD><BODY><P> SQL SELECT COUNTRY, CITY_NAME, REGION </P><P>FROM Countries </P><P>LEFT&nbsp; JOIN Cities</P><P>ON countries = cities</P></BODY></HTML> Tue, 20 Mar 2018 07:47:49 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53270#M782708 manoj217 2018-03-20T07:47:49Z Re: custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53271#M782709 <HTML><HEAD></HEAD><BODY><P>SQL SELECT CITIES.COUNTRY, CITIES.CITY_NAME, REGION </P><P>FROM COUNTRIES</P><P>LEFT OUTER JOIN CITIES</P><P>ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE</P></BODY></HTML> Tue, 20 Mar 2018 07:48:28 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53271#M782709 manoj217 2018-03-20T07:48:28Z Re: custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53272#M782710 <HTML><HEAD></HEAD><BODY><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">Try this once</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;"></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">SQL SELECT COUNTRY, CITY_NAME, REGION</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">FROM Countries a,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">Cities b</SPAN></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">where </P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">a.</SPAN>countries(+) = <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">b.</SPAN>cities</P></BODY></HTML> Tue, 20 Mar 2018 08:09:07 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53272#M782710 shiveshsingh 2018-03-20T08:09:07Z Re: custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53273#M782711 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">You are missing alias in your SQL </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">SQL SELECT CITIES.COUNTRY, CITIES.CITY_NAME, REGION</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">FROM COUNTRIES <SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>COUNTRIES</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">LEFT OUTER JOIN CITIES <STRONG>CITES</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">ON CITIES.COUNTRY_ISO_CODE = COUNTRIES.COUNTRY_ISO_CODE</P></BODY></HTML> Tue, 20 Mar 2018 09:28:37 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53273#M782711 sasiparupudi1 2018-03-20T09:28:37Z Re: custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53274#M782712 <HTML><HEAD></HEAD><BODY><P>again im getting the same error </P></BODY></HTML> Tue, 20 Mar 2018 10:55:58 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53274#M782712 manoj217 2018-03-20T10:55:58Z Re: custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53275#M782713 <HTML><HEAD></HEAD><BODY><P>what kind of error are you getting??</P><P>can you post it??</P><P>also post document log of qvw.</P><P></P><P>Regards</P></BODY></HTML> Tue, 20 Mar 2018 11:18:30 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53275#M782713 PrashantSangle 2018-03-20T11:18:30Z Re: custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53276#M782714 <HTML><HEAD></HEAD><BODY><P>what kind of error are you getting??</P><P>can you post it??</P><P>also post document log of qvw.</P><P></P><P>Regards</P></BODY></HTML> Tue, 20 Mar 2018 11:18:30 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53276#M782714 PrashantSangle 2018-03-20T11:18:30Z Re: custom SQL join in qlikview https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53277#M782715 <HTML><HEAD></HEAD><BODY><P>for alias I have used as so that's y im getting an error&nbsp; thanks for your suggestion</P><DIV class="j-act-sub-preview"><DIV class="j-author-act font-color-meta-light"><A _jive_internal="true" data-avatarid="11884" data-externalid="" data-online="false" data-presence="null" data-userid="198252" data-username="sasiparupudi1" href="https://community.qlik.com/people/sasiparupudi1"><SPAN style="color: #0066cc; text-decoration: underline;">Sasidhar Parupudi</SPAN></A></DIV></DIV></BODY></HTML> Thu, 22 Mar 2018 07:53:47 GMT https://community.qlik.com/t5/QlikView/custom-SQL-join-in-qlikview/m-p/53277#M782715 manoj217 2018-03-22T07:53:47Z