Thanks that worked.

When I first tried it, it didn't do any different than a left join (on my tables). Your code worked.

then I realized that I needed to "select...

So if I'm understanding correctly...

If this is just a standby server database, I can do it in standby, and it will be functional except for when a restore is taking...