Hi Albert,
I'm not using "UNION ALL" just "UNION" so they should be equivalent.

>David has the explanation of the performance difference, but are you aware that the two selects are not equivalent? The select with the union will give two rows whenever (C.Addrnum = A.Addrnum AND C.PAddrnum = A.Addrnum).