>>Yes, that "theory"
has now changed - actually since almost 2 years, I think. You must read the threads here more carefully < s >
>
>I guess I missed those ones.
>
>>While it is general concensus that the situation has NOT changed over the years, I remain a doubter on that specific issue. That is, I feel that it HAS TO HAVE CHANGED somewhere along the line.
>>
>>In any case, DELETED() TAG is BAD FORM
now with DELETED set ON and especially with bigger tables.
>
>Well, in my case, it's not an issue of big tables. 3000 records with INNER JOIN shouldn't be that much of an issue.
Michel,
Another idea:
If the data is for a report, it often helps to divide a multi-table query into several queries - select one or two tables first, and then add one table at a time.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)