On Mon, 12 Jul 2021, Rob Sargent wrote:
Having a hard time seeing the value in p.lname = p.lname and straight sql.
Me, too. That's why I wanted an explanation. Seems to me I added it sometime for no valid reason. As I've not run that query in a very long time I'll clean up the query and test it with the next opportunity. Rich