>
>A query like this would clean them out, but it might take a while to process:
>
>Delete
>From Calls
>Where CallDate < '4/1/98'
> And Not Exists
> ( Select AccountID
> From SubAccounts
> Where Calls.Usernmame = SubAccounts.Login
> Or Calls.Usernmame = SubAccounts.Shell
> Or Calls.Usernmame = SubAccounts.EMail
> )
Usernmame is not a valid column. It took me 4 hours to finally see that
extra m,
Michael J. Whisenant
Vice-President, Operations
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329