Yes, #temp is refered to 3 times with three different aliases: 't1' & 't2' in the main query and 't' in the sub query. I suppose I could have used t3 as the alias in the subquery to make it more obvious.

Peter