Assigning a parent-child mapping

[Anonymous]

Hi,

I have a pair of identifiers that are linked by an AGENTID:

AGENTID	ISSUERID
555	1234567
555	1234568

ISSUERID 1234567 is the "parent" and ISSUERID 1234568 is the "child". I want to create a new column in my table named PARENT_ISSUERID, and assign the value of 1234567 to the new field, for the "child" row - so, the result would look like this:

AGENTID	ISSUERID	PARENT_ISSUERID
555	1234567	-
555	1234568	1234567

How can I achieve this result in a load script?

I have thousands of pairings like this, so the "parent" and "child" ISSUERID values cannot be hard-coded - I am just using 1234567 and 1234568 as examples.

Many thanks,

VB

[#2]

so You've got the pairings on a separate table right?

You could use left join function... i guess