Re: [Emerald] Temp Extends...

( dan@dmn.com.au )
Thu, 17 Feb 2000 10:48:53 +0800

select su.login from masteraccounts ma, subaccounts su where
su.customerid=ma.customerid and (ma.extension>0 or su.extension>0)

Regards,

Dan Tang
Domain Technology
========================================================
========================================================
----- Original Message -----
From: "David Routh" <drouth@davlin.net>
To: <emerald@iea-software.com>
Sent: Thursday, February 17, 2000 10:32 AM
Subject: [Emerald] Temp Extends...

> Hello,
>
> Can someone help me with an SQL query that would list all accounts that
> have a Temporary Extend greater than 0.
>
> I'm going to play with what I think produce that but then I'm not real
> proficient with SQL.
>
> Thanks, David
>
>
> 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