xxxxxxxxxx
SELECT supplier_id, supplier_name
FROM suppliers
WHERE supplier_id <= 500
UNION
SELECT company_id, company_name
FROM companies
WHERE company_name = 'Apple'
ORDER BY 2;
xxxxxxxxxx
SELECT a.* FROM ((SELECT id FROM mes_report_flow_card) UNION ALL (SELECT id FROM mes_report_part_work_order )) AS alimit 0,10;