I would imagine you might want to join the table in the main query and the sub query. If that is what you want try this
set inventotyADG.ListPrice = inventory.user3
from inventory, inventoryADG
Originally posted by hsuzuki
I am trying to update a field in one table - based on data stored in another table and was wondering what the SQL statement may look like ?
set inventotyADG.ListPrice = (select inventory.user3
but it doesn't work
Anyway, any help would be appreciated.