Insert into planet_pos_replication_logins 
(  tenant_no
      ,pos_cd
      ,user_nm
      ,password
	  )
	  SELECT tenant_no, pos_cd ,'repagent','df!234Sd2' from points_of_sale where pos_cd not in (select pos_cd FROM planet_pos_replication_logins )