Select m_shop.shopID, m_shop.shopName, m_shop.areaID, m_shop.email,
m_shop.estimate_email, m_shop.url, m_shop.tel, m_shop.fax, m_shop.holiday,
m_shop.openClose, m_shop.dc_flg, m_area.areaName, m_car.car_name As dc_name,
m_shop.tc_flg, m_car1.car_name As tc_name, m_shop.zipcode, m_shop.address,
m_shop.message, m_shop.gmap
From m_shop Left Join
m_area On m_shop.areaID = m_area.areaID Left Join
m_car On m_shop.dc_flg = m_car.carID Left Join
m_car m_car1 On m_shop.tc_flg = m_car1.carID WHERE tc_flg = 3;
スズキ カスタムショップ｜販売店検索
試乗車 ALTO WORKSがある販売店一覧
地図・住所検索結果 店舗一覧です。
クモイモータース
514-2211三重県津市芸濃町椋本5038-1
TEL：059-265-2137
FAX：059-265-4637
営業時間：9:00～18:00
定休日：水曜日
