By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,458 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

After merging - how to bring over parent_ids

P: n/a
I have a table A with the following columns:

A.id
A.parent_id
A.z_id
A.z_parent_id
A.schema

The values of A.parent_id are currently null and require assigning.

The values in the columns z_id and z_parent_id come from an identical
table migrated from another database.

With your tip we will update the value of parent_id to the value
associated with a row in the current table that corresponds to the
parent id in the old table z.
Example:

id 4923 cooresponds to z_id 852

id 4343
parent_id (statement needed to assign this value 852)
z_parent_id 4923
Thanks.

Jul 18 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.