Re: [Emerald] Temp Extends...

David Routh ( drouth@davlin.net )
Wed, 16 Feb 2000 20:50:25 -0600

At 10:48 AM 02/17/2000 +0800, you wrote:
>select su.login from masteraccounts ma, subaccounts su where
>su.customerid=ma.customerid and (ma.extension>0 or su.extension>0)
>

Thanks Dan...

David

>
>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
>

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart