平成30/ 2018-12-14 11:05
MYSQL/ UNION

// union で重複削除できる

select
   id, name
from memo inner join grp_memo on memo.id = grp_memo.memo_id
union
select
    id, name
from memo
where published
order by id, name



// Thanks.
取得データの結合
http://www.dbonline.jp/mysql/select/index18.html