Is there a way to 'merge' to tables?

[PogoWolf]

to physically merge to tables of data, in SQL/Access? ---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?

http://www.pogowolf.com

http://www.xboxnewsnet.com

 

[Cagliostro]

What is the trouble? John Fill

ivfmd@mail.md

 

[MichaelRed]

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

 

[Cagliostro]

Just insert this union into a different table as:
insert into xxx
dfngSGFHNBNQADGMA;CVBMCXVs.....
union
anrfbinatgbnhrtyqut-yuqyq53uy-fmvbzx..... John Fill

ivfmd@mail.md

 

[PogoWolf]

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..?

http://www.pogowolf.com

http://www.xboxnewsnet.com

 

[MichaelRed]

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

 

[PogoWolf]

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..?

http://www.pogowolf.com

http://www.xboxnewsnet.com