update c
  set c.subscriberId=a.AttributeValue
  from cptbl c 
	join PanelAttributes a on a.PanelId=c.cpid and AttributeKey='Arcaccount'
 where 	subscriberId='' or subscriberId is null