>Is the syntax identical in profiler for both methods of issuing the command? Can you capture the query and post it?
I don't know what you mean by profiler. But, it ended up to be related to the fact that, from that environment, it is not possible to have the master table primary key in more than one record in the SQL results.