Hi,
this question is better suited for a SQL NG, you may get a better answer
there
the problem I see is with your relationships, you will need to "translate"
the relationships in two of the tables to not collide with the others
one possible way:
- Detect the MAX( subj_ID ) frmo table 1
- disable the FK in table 2
- Sum MAX ( subj_ID ) to each of subj_ID and parent_id in table 2
- enable the FK in table 2
- repeat 1 .. 4 in tables 2, table 3
do a insert /select of the tables in the targt table
cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Islamegy®" <Is******@Private.4me> wrote in message
news:e6**************@TK2MSFTNGP12.phx.gbl...
I have 3 Self-Referenced SQL Table with the same structure
(Subj_ID,Parent_ID, SubjText, Notes) with the child/Parent relation
between Subj_ID, Parent_ID.
subj_ID in all tables starting from 1,
Now i need to merge my 3 tables in one table without lose or destroy the
child/parent relation.
Is there anyway to do so... need help plz