Results 1 to 6 of 6
Thread: update with join erroring
Mar 16, 2011, 06:31 #1
- Join Date
- Sep 2008
- 0 Post(s)
- 0 Thread(s)
update with join erroring
I am trying to update on table with a sequence_number value from another table.
It errors out. Please can anyone explain what I am overlooking?
update page_blocks_stock set default_sequence = page_blocks_set.sequence_number FROM page_blocks_stock INNER JOIN page_blocks_set on page_blocks_set.page_block_name = page_blocks_stock.page_block_name WHERE page_blocks_set.business_id = 477 and page_blocks_set.live_dev = 'live' and page_blocks_set.script_name = 'default'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM page_blocks_stock as pbs
page_blocks_set as pbset
on pbset' at line 3