If you are using the query to control the selected records, use an inner join rather than a left join. You only want to return matching records, not all records.
Also, if the query is doing some aggregation, which it sounds like it is, you won't be able to make this work because ALL parts of a...