[thelist] some SQL cause I like to share

Warden, Matt mwarden at odyssey-design.com
Thu Jul 6 17:12:29 CDT 2000


> [tip type="SQL, conditional updates"]
> [/tip]


In the spirit...

<tip type="SQL, updating using multiple sources">
    Yeah, you can do this (not in Access, though):

    update table1 set val1 = b.val1 from table1_backup b where b.ID =
table1.ID

    Actually, I've really only done it in Sybase, but I found it on MSDN, so
I assume you can do it with most databases (since both Sybase AND microsoft
seem to support the same syntax).

</tip>





More information about the thelist mailing list