Hi All
I have multiple tables... all with the same composite key. well the tables are all the same layout infact.. just each table has a different row of data in each for ex.
table 1
ID field1 field2
1 test 0
2 box 0
3 three 0
4 can 0
5 meh 0
table 2
ID field1 field2
1 0 paper
2 0 envelope
3 0 box
4 0 lighter
5 0 jack
Now I combined both of these tables into one.. but its just like having the table ontop of the other.. i need to combine them both based on the key, whats the best way to do this? In the insert statement making sure the keys are equal when adding to the table, or elsewhere?
TIA
I have multiple tables... all with the same composite key. well the tables are all the same layout infact.. just each table has a different row of data in each for ex.
table 1
ID field1 field2
1 test 0
2 box 0
3 three 0
4 can 0
5 meh 0
table 2
ID field1 field2
1 0 paper
2 0 envelope
3 0 box
4 0 lighter
5 0 jack
Now I combined both of these tables into one.. but its just like having the table ontop of the other.. i need to combine them both based on the key, whats the best way to do this? In the insert statement making sure the keys are equal when adding to the table, or elsewhere?
TIA
