merging two tables that are not identical

Let's say that all the fields in Table 2 are in Table 1 - but not the
reverse. Do I have to add in fields to Table 2 in order to merge them
properly, even if I am leaving the data in them blank? Or perhaps I can
merge them and then whichever fields Table 2 does not have (let's say Table 2
has 5 columns and Table 1 has 20) - would just automatically be in there but
be blank.

Thanks for your help,
--
knuble07

Please stick to one post. If someone tries to do something similar in the
future, they need to be able to follow your post from question all the way
through answer. You have already started a thread related to this issue.
You need to continue posting to that thread.

Now, you are saying that some fields are in both table1 and table2, but
there are some fields missing.

You need to give us details. What type of data is this? If you have five
fields in each table that are the same (let's say EmployeeNumber, FirstName,
LastName, etc.) but you have other fields that are only tracked for certain
types of employees, then you need several RELATED tables. All the common
data (name, address, etc.) should be stored in one main table. The related
tables would contain the extra data *when needed* and would be related to
the main table.

Without posting a new thread, please respond with some details about your
tables. What are you storing?

--
Rick B



"HaLevi" wrote in message
...
Let's say that all the fields in Table 2 are in Table 1 - but not the
reverse. Do I have to add in fields to Table 2 in order to merge them
properly, even if I am leaving the data in them blank? Or perhaps I can
merge them and then whichever fields Table 2 does not have (let's say
Table 2
has 5 columns and Table 1 has 20) - would just automatically be in there
but
be blank.

Thanks for your help,
--
knuble07

Sorry about the different threads. I thought they were different questions.
See the other question for more detail.
--
knuble07


"Rick B" wrote:

Please stick to one post. If someone tries to do something similar in the
future, they need to be able to follow your post from question all the way
through answer. You have already started a thread related to this issue.
You need to continue posting to that thread.

Now, you are saying that some fields are in both table1 and table2, but
there are some fields missing.

You need to give us details. What type of data is this? If you have five
fields in each table that are the same (let's say EmployeeNumber, FirstName,
LastName, etc.) but you have other fields that are only tracked for certain
types of employees, then you need several RELATED tables. All the common
data (name, address, etc.) should be stored in one main table. The related
tables would contain the extra data *when needed* and would be related to
the main table.

Without posting a new thread, please respond with some details about your
tables. What are you storing?

--
Rick B



"HaLevi" wrote in message
...
Let's say that all the fields in Table 2 are in Table 1 - but not the
reverse. Do I have to add in fields to Table 2 in order to merge them
properly, even if I am leaving the data in them blank? Or perhaps I can
merge them and then whichever fields Table 2 does not have (let's say
Table 2
has 5 columns and Table 1 has 20) - would just automatically be in there
but
be blank.

Thanks for your help,
--
knuble07