select Login,
(select
SUM(Calls.AcctsessionTime)
from Calls
where Login = Username
)
as Charge_In_Cents
from SubAccounts
where AccountType = 'Minute Charge'
Notice this will report the amount owing on time usage at 60c/min.
----------------------------------------
Don Barron
Network Administrator
World-Link Internet
Ph: (08) 8231 0999
Fax: (08) 8212 8805
don@world-link.com.au
http://www.world-link.com.au
----------------------------------------
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart