------_=_NextPart_001_01BF7FD8.E35D0B54
Content-Type: text/plain;
charset="iso-8859-1"
SELECT CustomerID FROM SubAccounts GROUP BY CustomerID HAVING
COUNT(AccountID) > 1
-----Original Message-----
From: Gulam Chagani [mailto:gulam@catsgroup.com]
Sent: Friday, February 25, 2000 3:32 PM
To: emerald@iea-software.com
Subject: [Emerald] help with SQL query
Hi,
Can someone help me formulate a query to get all MBRs which have more than 1
service associated with it.
Help much appreciated.
Gulam Chagani
http://www.cats-net.com <http://www.cats-net.com>
------_=_NextPart_001_01BF7FD8.E35D0B54
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
------_=_NextPart_001_01BF7FD8.E35D0B54-------Original Message-----
From: Gulam Chagani [mailto:gulam@catsgroup.com]
Sent: Friday, February 25, 2000 3:32 PM
To: emerald@iea-software.com
Subject: [Emerald] help with SQL queryHi,Can someone help me formulate a query to get all MBRs which have more than 1 service associated with it.Help much appreciated.Gulam Chagani