Why read the persons table three times when you only have to read it once?
I have seen this type of query SOOO many times at clients over the years. I currently have one that has a DISASTROUS propensity for it!! :Whistling:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service