Yah, That is what I ended up doing.

If the select worked it would speed up the process. Table Y and X are the same. Table Y is a subset of X which them
I'm going to do some update work on it.

But any way I'm still wondering why I got the error when the docs state that it can be done.

Manny