On Oct 12, 2010, at 8:35 PM, Jon Clements wrote: > 4) Execute an update with a from statement joining your main table and > temp table (pretty sure that's ANSI standard, and DB's should support > it -- embedded one's may not though, but if you're dealing with 1mil > records, I'm taking a guess you're not dealing with embedded)
Not ANSI. Perhaps with a subquery, which is ANSI-compliant. -- http://mail.python.org/mailman/listinfo/python-list