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

eeek help

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
EEEK -
you haven't made it clear what the result is that you want.
Do you want a final table with 5 fields like this:
ID
Field1FromTable1
Field2FromTable1
Field1FromTable2
Field2FromTable2
?

Or something else?
"Beacher" <be*****@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.