It's the same as using RECNO(). Basically, the Query engine may reopen the table in a different alias, making the parameter useless. When you query from a single table, the query engine basically filters the table.
>Hi everyone!
>
>I know that "Where Deleted(table)" inside SQL query may cause unpredictable results, but i don't know when it hapen. In all queries or in specific queries with joins???
>
>Normally I don't have problem with only one "Deleted(table)" into the query's "Where" part, but ocassionally yes.
>
>Somebody knows???
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer