Larry;

This solves the error but perhaps does not address your requirement.

Use a different name for each table. I used #tmpTable and #tmpTable1 and it worked fine. It would not allow me to use the same tablename in both areas of the conditional statement.

Tom