[thelist] MS Access SQL Tip
Warden, Matt
mwarden at odyssey-design.com
Wed Nov 1 19:33:11 CST 2000
i just spent the last 20 minutes or so on this, so...
i assume this will work in other databases too...
<tip>
need to update from two differently-structured tables in Access (and possibly
other databases)? Try something like:
UPDATE MP_Item, imagemapping AS a
SET ItemImageURL = a.detail, ItemImageThumbURL = a.thumb
WHERE ucase(a.itemnumber)=ucase([MP_Item].[ItemNumber]);
</tip>
--
mattwarden
mattwarden.com
More information about the thelist
mailing list