>>>>Try
>>>>
>>>>
>>>>NOT DELETED("Links")
>>>>
>>>>
>>>You cannot use function like DELETE() with alias as parameter in SELECTS.
>>
>>Really! I could not varify my suggestion. I do not have a copy of VFP with here.
>
>Really. Alias you specify refers to the original table but SQL SELECT doesn't use open tables but reopens them again under different alias (similar to USE AGAIN).
Thanks for clarification.
Greg Reichert