[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