update 2 tables in one statement

[abware]

why? why this is not working?
I can’t update 2 tables in one statement?

update pd, p
set pd.show = 0 , pd.seashow = 0, p.StockLimited = 0
FROM ProductDetail pd
join Products p on p.itemid = pd.ItemID
where pd.show = 1
and pd.site in (5,2,9)

 

[LKBrwnDBA]

Your syntax is incorrect, looks like WinDoze T-SQL.

Check the fine Oracle Manual for correct syntax.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

Ooops, sorry -- Though I was on the Oracle forum.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb