[Emerald] deactivating many subaccounts

Josh Hillman ( (no email) )
Sun, 16 May 1999 20:41:03 -0400

What SQL script would I use to deactivate (set sa.active=0) all services
that are associated with MBRs that have already been deactivated
(ma.active=0)? I know conceptually how to do this, but don't know the
correct syntax for it when dealing with "update"... I already know that
marking the MBR inactive prevents invoicing, authentication, etc.