https://community.qlik.com/t5/Talend-Studio/Self-Join/m-p/2337942#M106233 to do a self join you will need to pull in the source table twice. This means 2 input components selecting from the same table. if you need to self join more than once you will need another db input for each join. <BR />please excuse my ascii art-- Im a programmer, not an artist <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA9p.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138034i5F552429DA646D6F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA9p.png" alt="0683p000009MA9p.png" /></span> <BR /> main <BR />tDatabaseInput -------&gt; +-------+ <BR /> lookup | tMap | <BR />tDatabaseInput -------&gt; +-------+ Tue, 16 Jun 2009 18:48:46 GMT Anonymous 2009-06-16T18:48:46Z https://community.qlik.com/t5/Talend-Studio/Self-Join/m-p/2337941#M106232 Hi,<BR />I'm new to open studio. I'm trying to do a self join on a row, but I can't figure out how to make it work. I've tried replicating the row and then sending it into a Join or tMap, but both rows comping out of the tRelpicate are Main rows. Is there a way to do this? I've tried searching for self-join on the forums, but I can't find anything. <BR />Thanks,<BR />George Sat, 16 Nov 2024 13:54:53 GMT https://community.qlik.com/t5/Talend-Studio/Self-Join/m-p/2337941#M106232 _AnonymousUser 2024-11-16T13:54:53Z https://community.qlik.com/t5/Talend-Studio/Self-Join/m-p/2337942#M106233 to do a self join you will need to pull in the source table twice. This means 2 input components selecting from the same table. if you need to self join more than once you will need another db input for each join. <BR />please excuse my ascii art-- Im a programmer, not an artist <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA9p.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138034i5F552429DA646D6F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA9p.png" alt="0683p000009MA9p.png" /></span> <BR /> main <BR />tDatabaseInput -------&gt; +-------+ <BR /> lookup | tMap | <BR />tDatabaseInput -------&gt; +-------+ Tue, 16 Jun 2009 18:48:46 GMT https://community.qlik.com/t5/Talend-Studio/Self-Join/m-p/2337942#M106233 Anonymous 2009-06-16T18:48:46Z