SELECT * FROM table_name1 LEFT JOIN table_name2 ON table_name1.no=table_name2.ismember order by table_name2.name