sql语句合并，一个sql语句查出多个sql语句需要查询的值。

需求场景：

	1.在查询语句时，需要查询两个或者两个以上的值（如A、B、C）
	2.A、B、C每个值的获取也需要单个sql语句进行查询出来。
	3.通过一个sql语句将A、B、C语句全部查询出来。

先把自己需要的查询分开写一下。

SELECT replacedate AS Recent_Date FROM x WHERE accessoriesid = "AB10001" ORDER BY replacedate DESC LIMIT 1

SELECT replacedate AS Earlier_Date FROM x WHERE accessoriesid = "AB10001" ORDER BY replacedate ASC LIMIT 1

加括号合在一起，注意，如果括号内部搜索结果用了别名（select x as cc）外部的select搜索的就是cc

SELECT
	a.replacedate AS Earlier_Date,
	b.replacedate AS Recent_Date 
FROM
	( SELECT replacedate  FROM x WHERE accessoriesid = "AB10001" ORDER BY replacedate ASC LIMIT 1 ) a,
	( SELECT replacedate  FROM x WHERE accessoriesid = "AB10001" ORDER BY replacedate DESC LIMIT 1 ) b