declare @quoteNo varchar(20) set @quoteNo = '{0}' select q.[Customer No_] [CustomerNo] , c.Name [Name] from [ExpressSeed$ES Quote Customer] q(nolock) join [ExpressSeed$Customer] c(nolock) on c.No_=q.[Customer No_] where q.[Quote No_]= @quoteNo {1} order by c.Name