Update a table from selecting another table

[marist89]

Originally posted by chrisrlong
Sorry Jeff, but that one won't work. Y is un-defined at the outer level

I stand corrected.