mysql将两条数据的同一字段在一条数据中展示

第一中方法：

SELECT
	m.appnum AS appnum,
	m.appname AS appname,
	m.appdowncoun AS appdowncoun,
	m.length AS length,
	m. LEVEL AS LEVEL,
	m.appinstalledname AS appinstalledname,
	MAX(
		(
			CASE n.type
			WHEN 0 THEN
				n.filepath
			ELSE
				''
			END
		)
	) AS apk,
	MAX(
		(
			CASE n.type
			WHEN 1 THEN
				n.filepath
			ELSE
				''
			END
		)
	) AS pic
FROM
	t_app m,
	t_fileinfo n
WHERE
	(m.appnum = n.appid)
GROUP BY
	m.appnum

第二种方法：

SELECT
	m.appnum AS appnum,
	m.appname AS appname,
	m.appdowncoun AS appdowncoun,
	m.length AS length,
	m. LEVEL AS LEVEL,
	m.appinstalledname AS appinstalledname,
	n.apk AS apk,
	n.pic AS pic
FROM
	t_app m
LEFT JOIN (
	SELECT
		t1.appid,
		t1.filepath AS apk,
		t2.filepath AS pic
	FROM
		t_fileinfo t1,
		t_fileinfo t2
	WHERE
		t1.type = 0
	AND t2.type = 1
	AND t1.appid = t2.appid
) n ON m.appnum = n.appid