The flag is where the AccountTypes.ChargeTypeID is NULL or not.
> -----Original Message-----
> From: Dale E. Reed Jr. <daler@iea-software.com>
> To: emerald@iea-software.com <emerald@iea-software.com>
> Date: Wednesday, 31 March 1999 8:01
> Subject: Re: [Emerald] Report
>
> >> Gary Wilkinson wrote:
> >>
> >> I am currently writing a report and I need to find the information in
> >> the tables that determines if the user is going to be charged a
> >> connection fee.
> >>
> >> Could someone point me in the correct direction.
> >
> >Do you mean a setup fee? You need to see if the ChargeTypeID
> >is NULL or null for their account type. If its not NULL, then
> >find that ID from the ChargeTypes table and thats the setup
> >charge. Like:
> >
> >Select SubAccounts.Login, AccountTypes.AccountType, AccountTypes.Cost,
> >ChargeTypes.Amount
> >From SubAccounts, AccountTypes, ChargeTypes
> >Where SubAccounts.AccountType = AcountTypes.AccountType
> > and AccountType.ChargeTypeID *= ChargeTypes.ChargeTypeID
> >
> >
> >--
> >
> >Dale E. Reed Jr. Emerald and RadiusNT
> >__________________________________________
> >IEA Software, Inc. www.iea-software.com
> >
> >For more information about this list, including removal,
> >please see http://www.iea-software.com/maillist.html
>
> For more information about this list, including removal,
> please see http://www.iea-software.com/maillist.html
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html