Yeah, really should have mentioned that Pervasive thing to begin with :-). That means there are multiple rows being returned for each lookup. Which one you get will be random, but as long as all of them are the same, it won't matter. It seems as if the TOP is valid for Pervasive:
(SELECT TOP 1 job_op_wc.workcenter
FROM v_job_operations_wc job_op_wc
WHERE job_op.job = job_op_wc.job) AS workcenter
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!