Forum Discussion
Update query to change data in a table
Table A has: HorseID (Number), HorseName (text) Table B has: HorseID (Number), HorseName (text) I want to update Table B HorseName to be the same as Table A Horsename, the HorseID would be the same...
I've got this far
UPDATE tblHorseInfo INNER JOIN tblInvoice ON tblHorseInfo.HorseID = tblInvoice.HorseID SET
WHERE (((tblHorseInfo.HorseName)<>""));
UPDATE tblHorseInfo INNER JOIN tblInvoice ON tblHorseInfo.HorseID = tblInvoice.HorseID SET
WHERE (((tblHorseInfo.HorseName)<>""));
"SET [TableB].[HorseName] = [TableA].[Horsename];"
See the difference?
"SET WHERE (((tblHorseInfo.HorseName)<>""));"