I posted this earlier (around 4/25) but somehow it is gone.  Here it is again:

This...

Thank you all for very insightful and helpful input.

I studied and tried all the SQL statements provided.  The first, by Michelle , generated a 'Subquery generated more than 1 value' error. ...

This solution is exactly what I was looking for ... originally.  I have implemented your code and it works, as you said, without using the...

Thank you all for your input - very insightful and helpful.  Here is what I tried and what worked.

First I tried using the "Set Quoted_Identifier Off" approach, which works well...