I am (desperately) trying to update a field in table A with the result of a query on table B, as an example :

REPLACE INTO TableA (Value) SELECT COUNT(data1) FROM TableB WHERE data1 BETWEEN 2 AND 4

I need to modify this so that the result is stored (for example) where TableA.id=1, but at the moment it just appends to the end of Table A sorry if this is a dumb ass question!! I have scoured the manual etc, but cannot find how to include the reference to table A's id field as well!