I have one table with the following fields:
quote_info: quote_number, reps, location, model, product, job_title
this is messy but i want to get the details for each distinct quote_number, product pair and the reps that have job_title like 'sales_rep'
so a simple distinct isn't going to cut it here... I need the details for each quote_number, product combination...