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;
SELECT a.* FROM ((SELECT id FROM mes_report_flow_card) UNION ALL (SELECT id FROM mes_report_part_work_order )) AS alimit 0,10;
www.techonthenet.com