Positional Join and referential Integrity
<p>I have the below diagram of how a referential integrity between rows in a textfile should be joined by using a positional join.</p>

<p>The text files look like this:</p>

<p>I have had to insert each row from the text file into its own table depending on the value of the first column. I was wondering if anyone can make any sense of this using the diagram and also the notepad file. The I26, I28, I27 and I99 are positional join and its the one I am having a problem getting my head around.</p>

<p>If anyone has done this please could you provide a possible solution in terms of doing a join for all 4 values mentioned above.</p>

<p>I haven't got enough knowledge around the subject matter, kinda been dumped with it so I am happy to take your own assumptions around how the joins should be. </p>