Error: <br />Error No: <br />SELECT r.region_id, r.name, ron.output_name 
            FROM sf_region r
            INNER JOIN store_to_region_output_name ron ON(r.region_id = ron.region_id AND ron.status = 1 ) 
            WHERE output_name IS NOT NULL AND store_id = 0