SELECT
    m1.car_management_no,
    t1.contract_no,
    t2.contract_detail_no,
    (SELECT shop_name FROM nmrm_shop m2 WHERE m1.shop_id = m2.shop_id AND m2.shop_name LIKE '”L%')
FROM nmrm_rent_car m1
INNER JOIN nmrt_contract t1
    ON (m1.car_management_no = t1.car_management_no)
INNER JOIN nmrt_contract_detail t2
    ON (t1.contract_no = t1.contract_no);