update table name
set (inventory,sale,purchase)=Y
where itemcode =rem0012 and inventroy=N
update OITM
set InvntItem ='N'
where itemcode ='SFG0920' and InvntItem = 'Y'
set (inventory,sale,purchase)=Y
where itemcode =rem0012 and inventroy=N
update OITM
set InvntItem ='N'
where itemcode ='SFG0920' and InvntItem = 'Y'