221201 (목)

✔ Mapper에서 사용할 SQL문 작성  

SELECT td.ticket_id, td.city_id, td.ticket_name, td.ticket_location, td.ticket_score,date_format(td.ticket_due_date, '%Y.%m.%d') AS ticket_due_date, td.ticket_adult_price, td.ticket_child_price, ti.ticket_rep_img_path, ti.ticket_detail_img_path, ct.city_name
FROM ticket_detail td
LEFT JOIN ticket_img ti
  ON td.ticket_id = ti.ticket_id
LEFT JOIN  city ct
  ON td.city_id = ct.city_id
WHERE td.ticket_id = 'ti140002';