One Star

Self Join?

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.

Re: Self Join?

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.
please excuse my ascii art-- Im a programmer, not an artist Smiley Wink
tDatabaseInput -------> +-------+
lookup | tMap |
tDatabaseInput -------> +-------+