Re: Complex Update Queries with Fromlist

Thank you. That works for the simple example I had.

However, I have an additional question about this. What if I need to do
a LEFT OUTER JOIN in the Fromlist. For example, this query works but it
requires the orders table to appear twice.

UPDATE orders set requireddate =
(case when c.city in ('Seattle','Portland') then date(o.OrderDate) + 1

else date(o.OrderDate) + 2 end)
FROM orders o
LEFT OUTER JOIN customers c on
o.customerid = c.customerid
where c.region in ('WA','OR')
and orders.orderid = o.orderid

Is there some way to do an outer join in the Fromlist back to the main
table being updated without having it appear twice? Thanks.