replicate values

[gogaak]

helo all,

I have two tables I want to copy all the contents of column in tableA to coumn in tableB. How do i update it using queries..

please help

 

[Uncle Gizmo]

Assuming you have a field which is common to both tables:

See Attached

 

[gogaak]

thnx mate..

But the update doesnt seem to work...
the query runs , but doesnt update anything....
is there particular process to follow?

Sorry for the trouble

 

[Uncle Gizmo]

Did you press the "Copy Records" button?

 

[gogaak]

yes..
i cliked the copy records button..
i also tried to run the query.
but it shows its updating 0 rows..

 

[Uncle Gizmo]

Well, it works OK on my machine!