to physically merge to tables of data, in SQL/Access? ---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?
Darkness..Bleakness..Plastic forks..?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is there a way to 'merge' to tables?
- Thread starter PogoWolf
- Start date
Cagliostro
Programmer
What is the trouble? John Fill
ivfmd@mail.md
ivfmd@mail.md
MichaelRed
Programmer
Probably a bad idea. A union Query would give you a virtual merge, without the hazzardous side effects of the physical one.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
Cagliostro
Programmer
Just insert this union into a different table as:
insert into xxx
dfngSGFHNBNQADGMA;CVBMCXVs.....
union
anrfbinatgbnhrtyqut-yuqyq53uy-fmvbzx..... John Fill
ivfmd@mail.md
insert into xxx
dfngSGFHNBNQADGMA;CVBMCXVs.....
union
anrfbinatgbnhrtyqut-yuqyq53uy-fmvbzx..... John Fill
ivfmd@mail.md
- Thread starter
- #5
I'm really trying to pull off is 'normalizing' the data. Or just creating a good data structure.
I'm doing the testing of this DB in Access2k, and will be migrating it to SQL2k.. (in case it makes a difference)
I have a number of tables in a database. Each of those tables holds specific data, and are named logically like Company, DocType, And Owner.
What I'm thinking, is creating another table, that 'merges' all of this data into one table.
(possible one to many relationship)
So this look up table would have 3 Columns named: Type , Owner , and Data.
Where Type would be the 'type' of data (Company/DocType) and Owner (from the Owner Table)
and 'data' which would be the real data from that document..
The issue that I'm having is that due to an older data Structure, I other tables that have 'owner' and 'Data' already set up
and I would like dump this data into the new 'lookup' table so I don't need to type all of it in again.
So I guess, what I'm asking is.
Does anyone agree with this new data structure? and how do I go about 'merging the data. I would assume though the Union
SQL command, but I'll be going from 2 columns of data into 3.. will this cause problems?
---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?
I'm doing the testing of this DB in Access2k, and will be migrating it to SQL2k.. (in case it makes a difference)
I have a number of tables in a database. Each of those tables holds specific data, and are named logically like Company, DocType, And Owner.
What I'm thinking, is creating another table, that 'merges' all of this data into one table.
(possible one to many relationship)
So this look up table would have 3 Columns named: Type , Owner , and Data.
Where Type would be the 'type' of data (Company/DocType) and Owner (from the Owner Table)
and 'data' which would be the real data from that document..
The issue that I'm having is that due to an older data Structure, I other tables that have 'owner' and 'Data' already set up
and I would like dump this data into the new 'lookup' table so I don't need to type all of it in again.
So I guess, what I'm asking is.
Does anyone agree with this new data structure? and how do I go about 'merging the data. I would assume though the Union
SQL command, but I'll be going from 2 columns of data into 3.. will this cause problems?
---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?
MichaelRed
Programmer
Ignore all of my previous posting.
Form this POST, I think you are going awry, however it is not all that clear. I will "butt out" and hope that others have better insight and will offer a soloution.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
Form this POST, I think you are going awry, however it is not all that clear. I will "butt out" and hope that others have better insight and will offer a soloution.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
- Thread starter
- #7
to be honest.. after I posted that message, I relooked at the code, and what I Was trying to pull off, and I agree with you.. I think i was getting bogged down on the factors, and not the functions. =)
so I'm going to leave well enough alone. =)
---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?
so I'm going to leave well enough alone. =)
---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?
- Status
Similar threads
- Question
- Locked
- Question