I don't know about the unqualified reference, but I do know that the 'deleted' temp table frequently contains rows that are NOT really being deleted, like during updates.
Why wouldn't you have used a foreign key with cascaded deletes instead?
Tom
Tom Garth Vertical Solutions[/url]
"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers