> SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, (ma.Ex
>tension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), Dat
>eAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, sa.AccountType
>, sa.Password, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts
>sa Where (sa.Login='test' or sa.Shell='test') AND ma.CustomerID=sa.Cu
>stomerID and sa.Active<>0 and ma.Active<>0
Is all this above right or do you know?
As for all the rest, have you sent it to the list? We can work on this
together tomorrow if you like.