Insert values while currentID = PreviousID

[Nick_C]

ID1.............data
1.................data-1
2.................data-2
3.................data-3
etc

table2 looks like:

ID2..........data
a..............data-a1
a..............data-a2
a..............data-a3
b..............data-b1
b..............data-b2
b..............data-b3
c..............data-c1
c..............data-c2
etc

There are no common fields between the 2 tables.
Basically, what I need to do is to insert the id fields from table1 into table2 like this:

ID2...........ID1..........data
a..............1..............data-a1
a..............1..............data-a2
a..............1..............data-a3
b..............2..............data-b1
b..............2..............data-b2
b..............2..............data-b3
c..............3..............data-c1
c..............3..............data-c2
etc

I guess I need insert ID1 while ID2 is the same value as the previous row???
Else move on to the next instance of ID1 and repeat the cycle?

I can't do this, Please help!

Thanks in advance

Nick

[Nick_C]

Hello all!

Sorry - for some reason the beginning of my thread is missing?

Should read..............

I have 2 tables, table1 and table2. They have the following structure:

table1 looks like:

ID1.............data
1.................data-1
2.................data-2
3.................data-3
etc

table2 looks like:

ID2..........data
a..............data-a1
a..............data-a2
a..............data-a3
b..............data-b1
b..............data-b2
b..............data-b3
c..............data-c1
c..............data-c2
etc

There are no common fields between the 2 tables.
Basically, what I need to do is to insert the id fields from table1 into table2 like this:

ID2...........ID1..........data
a..............1..............data-a1
a..............1..............data-a2
a..............1..............data-a3
b..............2..............data-b1
b..............2..............data-b2
b..............2..............data-b3
c..............3..............data-c1
c..............3..............data-c2
etc

I guess I need insert ID1 while ID2 is the same value as the previous row???
Else move on to the next instance of ID1 and repeat the cycle?

I can't do this, Please help!

Thanks in advance

Nick

[djjjozsi]

In table1 you have a values:

ID1.............data
1.................a
2.................b
3.................c

Then in table2 why are you insert the two values from table1? You can JOIN these tables!

table2 should looks like:

table2:
ID2........ID1........data2
1 ........1.....................data1a
2 ........1.....................data1b
3 ........1.....................data1c
4 ........1.....................data1d
6 ........2.....................data2a
7 ........2.....................data2b
8 ........2.....................data2c
9 ........2.....................data2d

And what you want to do with these two tables?
And lets give us better examples from the two tables. I think you designed the two tables wrong.
Hello, jjozsi.

[Nick_C]

Thanks for the reply djjjozi.

I've not used the JOIN function, I'll look into it.

Many thanks for the tip!

Nick

PS: The tables already exsist from the structure I have had to inherit - Thanks