Home Forums SQL Server 7,2000 T-SQL Output results based on row comparison? RE: Output results based on row comparison?
Peter Tillotson
Hall of Fame
Points: 3325
More actions
June 25, 2004 at 5:04 am
#511932
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