https://community.qlik.com/t5/QlikView/How-to-rewrite-this/m-p/1855083#M1215842 <P>In this snippet we have to select item as per below SQL Logic in QlikView.</P> <P>(Select top 1 INSPD.UpdatedOn from InspAppDet INSPD where INSPD.ConID=AO.ConID and INSPD.IsAcknowledged='Y' and INSPD.IsTransActive='N' and INSPD.IsApprovedBy='Y' ORDER BY CreatedOn desc) 'L_APP_A_O'</P> <P>&nbsp;</P> <P>How can I achieve this, here two different tables are referred and two different conditions for join have been used and this table can be used by other available tables&nbsp;</P> <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/675">@MarcoWedel</a>&nbsp;Hi, May be you can help</P> Fri, 05 Nov 2021 07:27:16 GMT neerajthakur 2021-11-05T07:27:16Z https://community.qlik.com/t5/QlikView/How-to-rewrite-this/m-p/1855083#M1215842 <P>In this snippet we have to select item as per below SQL Logic in QlikView.</P> <P>(Select top 1 INSPD.UpdatedOn from InspAppDet INSPD where INSPD.ConID=AO.ConID and INSPD.IsAcknowledged='Y' and INSPD.IsTransActive='N' and INSPD.IsApprovedBy='Y' ORDER BY CreatedOn desc) 'L_APP_A_O'</P> <P>&nbsp;</P> <P>How can I achieve this, here two different tables are referred and two different conditions for join have been used and this table can be used by other available tables&nbsp;</P> <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/675">@MarcoWedel</a>&nbsp;Hi, May be you can help</P> Fri, 05 Nov 2021 07:27:16 GMT https://community.qlik.com/t5/QlikView/How-to-rewrite-this/m-p/1855083#M1215842 neerajthakur 2021-11-05T07:27:16Z