UPDATE A SET A.ChannelIdx=22, A.ModuleArrayIndex=8 FROM [dbo].[DASChannels] AS A INNER JOIN [dbo].[DAS] as B ON A.DASId=B.DASId WHERE B.SerialNumber LIKE '%TSR Air%' AND SupportedBridges=1024