shneusk

  UPDATE tblSubscriber
  SET ixCreditCard = -1
  WHERE fStudentAndStartup = 1

  USE FogShop
  DELETE
  FROM tblCreditCard
  WHERE ixCreditCard IN (
    SELECT ixCreditCard
    FROM tblSubscriber
    WHERE fStudentAndStartup = 1
  )