引用:

---

SELECT m_1.name,m_1.remark
FROM m_1
UNION ALL select m_22.name,m_22.remark
FROM m_22
UNION ALL select m_big.m_big,m_big.remark
FROM m_big
UNION ALL select m_m1.m_m1,m_m1.remark
FROM m_m1;
UNION ALL select m_m2.m_m2,m_m2.remark
FROM m_m2
UNION ALL select m_s.m_s,m_s.remark
FROM m_s
UNION ALL select m_s2.M_s,m_s2.remark
FROM m_s2
UNION ALL select p_big.m_big,p_big.remark
FROM p_big
UNION ALL select p_m1.m_m1,p_m1.remark
FROM p_m1
UNION ALL select p_m2.m_m2,p_m2.remark
FROM p_m2
UNION ALL select p_s.m_s,p_s.remark
FROM p_s;

---