join and update

December 5th, 2007, 11:55 AM

Michele

Guest

Posts: n/a

Where is the error in this update with join

update snx_comuni set sta_id = 2782
from snx_comuni
inner join snx_province on snx_comuni.provincia_id =
snx_province.provincia_id
inner join snx_regioni on snx_province.regione_id = snx_regioni.regione_id
where snx_regioni.codice_regione = 'PIE'

« previous question | next question »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to join update statement with select?	tksamy	answers	1	August 22nd, 2009 05:41 AM
get DB results from inner join update	Rick	answers	2	May 9th, 2007 03:35 AM
Update Trigger	Ryandmcbee	answers	1	November 22nd, 2006 05:20 PM
Update Query (Access vs. SQL Server)	ralph_noble@hotmail.com	answers	6	November 13th, 2005 07:41 AM

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 225,662 network members.