select_inspection_details.sql

-- Select the Inspection Details for a Given Id
SELECT i.inspection_visit_id, i.license_id, i.inspection_number,
       i.visit_number, i.inspection_class, i.inspection_type,
       i.inspection_disposition, i.inspection_date, i.total_violations,
       i.high_priority_violations, i.intermediate_violations,
       i.basic_violations, i.pda_status, i.county_number,
       r.license_type_code, r.license_number,
       r.business_name, r.location_address, r.location_city, r.location_zipcode,
       c.county_name, c.district
  FROM inspections AS i
 INNER JOIN counties AS c
    ON c.county_number = i.county_number
 INNER JOIN restaurants AS r
    ON r.county_number = i.county_number
   AND r.license_number = i.license_number
 WHERE inspection_visit_id = :id;