Query help needed.

[Parker Clack]

I am wanting to copy a column in one table to another table.

Specially I am wanting to copy the data in table userfield2 column fileld15 to table userfield column15.

Any help would be appreciated.

Thanks,
Parker

[Zachariah]

UPDATE userfield
INNER JOIN userfield2 on userfield.userid = userfield2.userid
SET userfield.field15 = userfield2.field15;

This will:
update table userfield fileld15 with data from table userfield2 fileld15

[Adrian Schneider]

One typo in there - "INNTER" should be "INNER".

[Zachariah]

Originally Posted by SirAdrian

One typo in there - "INNTER" should be "INNER".

I seen and fixed that .
- I forgot to hit preview.

[Parker Clack]

Thanks for the help.

Parker