SELECT * FROM m_targetpref LEFT JOIN m0_pref USING(pref_cd) WHERE pref_alfname =  'nara'