[shneusk]

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

ok you won’t be charged now

[shneusk]

simpler:

  UPDATE tblSubscriber
  SET ixCreditCard = -1
  WHERE fStudentAndStartup = 1

[mathgeek]

Once a kiwi, always a kiwi!

[shneusk]

Heehee