AND ma.CustomerID = sa.CustomerID
If you leave that off, you'll get a LOT of results. :)
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com