Don't know about you but I've wondered on occasion whether or not it's possible to do a join update in Oracle and SQL Server as I've seen done in mySQL. For those who've never seen an update join, here's one to illustrate:
update invc_itemAs you can see in the example, this SQL re-queries calls twice - once for the update and once for the where.
set feed_id =
where invc_item_id = invc_item.invc_item_id)
where feed_id = 0
where invc_item_id = invc_item.invc_item_id
and feed_id > 0)
update iMuch simpler, far more efficient, and once you get the hang of it - less prone to error when doing these sorts of updates.
set i.feed_id = c.feed_id
from invc_item i, calls c
where i.feed_id = 0
and c.invc_item_id = i.invc_item_id
and c.feed_id > 0
I'm not sure whether or not you have to use the table aliases as I did. Haven't tested without. This is how it was illustrated in the documentation I found.
Now for the bad news... SQL Server (the toy wannabe database) supports it, Oracle does not.
Thanks for the help Scott...