hmmm, now the values are null.
actually, does anyone know if query results can be joined to like views? i.e. Update <table> inner join <query> on .... this may be a better solution for my problem.
i tried it and it didn't work for me, but i may have gotten the syntax incorrect.