SELECT Count(dbo_SubAccounts.Active) AS CountOfActive,
dbo_SubAccounts.AccountType
FROM dbo_MasterAccounts INNER JOIN dbo_SubAccounts ON
dbo_MasterAccounts.CustomerID = dbo_SubAccounts.CustomerID
WHERE (((dbo_SubAccounts.Active)=1) AND ((dbo_MasterAccounts.Active)=1))
GROUP BY dbo_SubAccounts.AccountType;
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of PowerNet
> Sent: Wednesday, March 29, 2000 6:04 PM
> To: emerald@iea-software.com
> Subject: RE: [Emerald] Script
>
>
> It seems like this could be active services.
> I need to make sure they are active MBR's
>
> It pulled up way too many services.
>
> *********** REPLY SEPARATOR ***********
>
> On 3/29/00, at 5:57 PM, Bernard Andrys wrote:
>
> >I use this in Access (note that dbo_Subaccounts is an odbc link to
> >SubAccounts):
> >
> >SELECT Count(dbo_SubAccounts.Active) AS CountOfActive,
> >dbo_SubAccounts.AccountType
> >FROM dbo_SubAccounts
> >WHERE ((dbo_SubAccounts.Active)=1)
> >GROUP BY dbo_SubAccounts.AccountType;
> >
> >> -----Original Message-----
> >> From: emerald-request@iea-software.com
> >> [mailto:emerald-request@iea-software.com]On Behalf Of PowerNet
> >> Sent: Wednesday, March 29, 2000 5:35 PM
> >> To: emerald@iea-software.com
> >> Subject: [Emerald] Script
> >>
> >>
> >> I am looking for an SQL query that will display the number of
> >> active customers by service type.
> >>
> >> Can anyone help.
> >>
> >> Thanks.
> >> John
> >>
> >>
> >> For more information about this list (including removal) go to:
> >> http://www.iea-software.com/support/maillists/liststart
> >>
> >
> >
> >For more information about this list (including removal) go to:
> >http://www.iea-software.com/support/maillists/liststart
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart