topic Re: How to join two tables as per below where clause in QlikView https://community.qlik.com/t5/QlikView/How-to-join-two-tables-as-per-below-where-clause/m-p/421237#M701315 <HTML><HEAD></HEAD><BODY><P>Try somenthing like this</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13480524120027257" jivemacro_uid="_13480524120027257"><P>LOAD&nbsp;&nbsp; </P><P>ORGANIZATION_CODE, </P><P>GROSS_WRITTEN_PREMIUM,</P><P> DISCOUNT,</P><P> OTHER_CHARGES,</P><P> GST, COMMISSION1,</P><P> COMMISSION2,</P><P> NET_WRITTEN_PREMIUM,</P><P> TRANSACTION_NUMBER;</P><P>SQL SELECT </P><P>ORGANIZATION_CODE, GROSS_WRITTEN_PREMIUM, DISCOUNT, OTHER_CHARGES, GST, COMMISSION1, COMMISSION2,</P><P> NET_WRITTEN_PREMIUM,</P><P> TRANSACTION_NUMBER</P><P> FROM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>DIM_ORGANIZATION INNER JOIN FT_PREMIUM_TRANSACTION&nbsp; ON </P><P>DIM_ORGANIZATION.ORGANIZATION_KEY = FT_PREMIUM_TRANSACTION.COMPANY_PARTY_KEY;</P><P></P><P></P></PRE></BODY></HTML> Wed, 19 Sep 2012 11:07:20 GMT 2012-09-19T11:07:20Z How to join two tables as per below where clause https://community.qlik.com/t5/QlikView/How-to-join-two-tables-as-per-below-where-clause/m-p/421235#M701313 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am a newbie in qlikview and quite unaware of qlikview scripting... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P>please help me in joining these two tables as per the below sql statement.</P><P></P><P>select ORGANIZATION_CODE, GROSS_WRITTEN_PREMIUM, DISCOUNT, OTHER_CHARGES, GST, COMMISSION1, COMMISSION2, NET_WRITTEN_PREMIUM, TRANSACTION_NUMBER</P><P></P><P>from DIM_ORGANIZATION, FT_PREMIUM_TRANSACTION</P><P></P><P>where DIM_ORGANIZATION.ORGANIZATION_KEY = FT_PREMIUM_TRANSACTION.COMPANY_PARTY_KEY</P><P></P><P>Please help me its little urgent..</P><P></P><P>Many Thanks</P><P>Kriti</P></BODY></HTML> Wed, 19 Sep 2012 09:56:11 GMT https://community.qlik.com/t5/QlikView/How-to-join-two-tables-as-per-below-where-clause/m-p/421235#M701313 2012-09-19T09:56:11Z Re: How to join two tables as per below where clause https://community.qlik.com/t5/QlikView/How-to-join-two-tables-as-per-below-where-clause/m-p/421236#M701314 <HTML><HEAD></HEAD><BODY><P>Also I have prepared separate QVDs for both the tables..</P></BODY></HTML> Wed, 19 Sep 2012 09:57:46 GMT https://community.qlik.com/t5/QlikView/How-to-join-two-tables-as-per-below-where-clause/m-p/421236#M701314 2012-09-19T09:57:46Z Re: How to join two tables as per below where clause https://community.qlik.com/t5/QlikView/How-to-join-two-tables-as-per-below-where-clause/m-p/421237#M701315 <HTML><HEAD></HEAD><BODY><P>Try somenthing like this</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13480524120027257" jivemacro_uid="_13480524120027257"><P>LOAD&nbsp;&nbsp; </P><P>ORGANIZATION_CODE, </P><P>GROSS_WRITTEN_PREMIUM,</P><P> DISCOUNT,</P><P> OTHER_CHARGES,</P><P> GST, COMMISSION1,</P><P> COMMISSION2,</P><P> NET_WRITTEN_PREMIUM,</P><P> TRANSACTION_NUMBER;</P><P>SQL SELECT </P><P>ORGANIZATION_CODE, GROSS_WRITTEN_PREMIUM, DISCOUNT, OTHER_CHARGES, GST, COMMISSION1, COMMISSION2,</P><P> NET_WRITTEN_PREMIUM,</P><P> TRANSACTION_NUMBER</P><P> FROM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>DIM_ORGANIZATION INNER JOIN FT_PREMIUM_TRANSACTION&nbsp; ON </P><P>DIM_ORGANIZATION.ORGANIZATION_KEY = FT_PREMIUM_TRANSACTION.COMPANY_PARTY_KEY;</P><P></P><P></P></PRE></BODY></HTML> Wed, 19 Sep 2012 11:07:20 GMT https://community.qlik.com/t5/QlikView/How-to-join-two-tables-as-per-below-where-clause/m-p/421237#M701315 2012-09-19T11:07:20Z Re: How to join two tables as per below where clause https://community.qlik.com/t5/QlikView/How-to-join-two-tables-as-per-below-where-clause/m-p/421238#M701316 <HTML><HEAD></HEAD><BODY><P>Thanks Pedro</P></BODY></HTML> Wed, 19 Sep 2012 12:04:55 GMT https://community.qlik.com/t5/QlikView/How-to-join-two-tables-as-per-below-where-clause/m-p/421238#M701316 2012-09-19T12:04:55Z