combine tables

[gal]

Hi group,
I have Table 1 and Table 2. How can I have a field from
table one added to Table2. I know if I use UpdateQ I'll
get the result, but I don't remember the syntax. ANd I
don't want to join the tables , because the second table
will be deleted once the desired field is transfered to
Table 1.

Thanks

 

[Rick B]

Build the new field into Table1, create an update query using the wizard
where Table1 new field is updated with Table2 field.

Rick B


Hi group,
I have Table 1 and Table 2. How can I have a field from
table one added to Table2. I know if I use UpdateQ I'll
get the result, but I don't remember the syntax. ANd I
don't want to join the tables , because the second table
will be deleted once the desired field is transfered to
Table 1.

Thanks

 

[Rick B]

oops - no update wizard. Sorry.

Build the query pulling Table1 into the quiry window.

Pull all the fields you want to see.

Add Table2 to the window, and create the link between the two tables.

Use the drop-down list to change your query into an update query.

In the Update To field, enter the table and field field to pull.

SQL would look something like...

UPDATE Table1 LEFT JOIN Table2 ON Table1.ClientNumber = Table2.CleintNumber
SET Table1.Address= [Table2].[Address];


This assumes you are grabbing "address" from Table2 and adding it to Table1.
It assumes both tables contain a "ClientNumber" field to use as a link.

Rick B



Hi group,
I have Table 1 and Table 2. How can I have a field from
table one added to Table2. I know if I use UpdateQ I'll
get the result, but I don't remember the syntax. ANd I
don't want to join the tables , because the second table
will be deleted once the desired field is transfered to
Table 1.

Thanks

 

[gal]

the fields are not related and the wizard cancel itself
what is the sql statemtent for this action