[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