$partquery = "
                SELECT DISTINCT a.Part_number,a.Part_type,a.Footnotes,b.Part_number, b.List,b.Jobber
                FROM brakes_bendix_glo_aaia,brakes_bendix_pre_aaia AS a JOIN brakes_bendix_price AS b
                ON a.Part_number = b.Part_number
                WHERE a.Year='$veh_year' AND a.Make='$veh_make' AND a.Model='$veh_model' AND a.Engine_liters='$veh_engine'
                ORDER BY b.Jobber ASC
            ";