Reason for the question - performance.
Building a sub-query (that will feed data to another query that is used by a report). I know that all records for a given criteria (JOB) will contain the same data for some fields - All the Orders combined into one production Job will use the same base material.
So, I really only need to retrieve the first (or simply one) record of all orders for the job. If I were creating this query in SQL I could use the term DISTINCT.
I used the "First" in the Totals: row to get the result.
Yadda, yadda, yadda - performance speed - Is there a technique to make this faster? (Some Jobs will combine up to 50 orders).
Building a sub-query (that will feed data to another query that is used by a report). I know that all records for a given criteria (JOB) will contain the same data for some fields - All the Orders combined into one production Job will use the same base material.
So, I really only need to retrieve the first (or simply one) record of all orders for the job. If I were creating this query in SQL I could use the term DISTINCT.
I used the "First" in the Totals: row to get the result.
Yadda, yadda, yadda - performance speed - Is there a technique to make this faster? (Some Jobs will combine up to 50 orders).
