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 ?
I used
update inventoryADG
set inventotyADG.ListPrice = (select inventory.user3
from inventory
where inventory.user3<>0)

but it doesn't work
Anyway, any help would be appreciated.

What is the error it is reporting back? IS it that the subquery returned more then one result??

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

update inventoryADG
set inventotyADG.ListPrice = inventory.user3
from inventory, inventoryADG
where inventory.user3<>0
and ...............

The problem is that the query

select inventory.user3
from inventory
where inventory.user3<>0

is returning more than 1 record. You need to post the schema for both tables and be more specific what you are trying to update.