[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...

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]);


More information about the thelist mailing list