It would be something like this:
Delete From Calls
Where Not Exists(
Select AccountID From SubAccounts
Where (Username = Login or Username = Shell or Username = email)
}
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com