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!
PLEASE HELP ME !
Chris Thorpe
Consultronics Europe Ltd
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php