mysql中两个没关联的数据合成

直接上代码:

两个表中的数据, 个数都要保持一样
例如: 1表中的名称和编码 那2表中也必须有名称和编码
如果用到分页外边必须加上 select * from 扩起来在进行分页

SELECT
	*
FROM
	(
		SELECT
			bom_name AS NAME,
			bom_code AS CODE,
			min_stock AS min,
			max_stock AS max
		FROM
			tr_bom AS a (表1)
		UNION ALL   (使用musql中的关键字)
			SELECT
				material_name AS NAME,
				material_code AS CODE,
				minimum_stock AS minimum_stock,
				maximum_stock AS max
			FROM
				tr_material AS b  (表2)
	) a
LIMIT 1,
 10