I have a query that pulls information from multiple tables. It works fine, except that one particular table might have more than one contractor for the job and I only want it to pull the single job.
I have job number 55512. I have three contractors for this job that are stored in the contractors table. I run a query for all jobs and it returns 55512 three times because it has three contractors in the contractor table. This particular query needs only the job and not the repeats for the contractor. The customer is fine with it pulling only the first contractor job, but it only wants it to pull it once into the query instead of three times.
How do I do this?