update AmountTable
set ValueColumn = (select AmountColumn from FruitTable where PrimaryId = 'SelectedValue' ) + (select ValueColumn from AmountTable where PrimaryId = 'SelectedValue')
where PrimaryId = 'SelectedValue'
you need to be more specific if you want more specific answer
Feb 6 2006, 04:40 PM
Quote
0.0130sec
0.26
6 queries
GZIP Disabled