RE: [Emerald] help with SQL query

Nathan Haywood ( nhaywood@whro.org )
Fri, 25 Feb 2000 16:40:07 -0500

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_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">

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
 
------_=_NextPart_001_01BF7FD8.E35D0B54--