mysql - 将两行结果合并为两列(mysql)

Question

这是file_tbl 这是name_tbl

我想要以下结果。

select email, file, name 
from file_tbl as ft 
join name_tble as nt on ft.email = nt.email 
where nt appId = 6

没有给出想要的结果。

如何实现这一目标？

Answer 1

这将是您可以使用的东西:

SELECT email,GROUP_CONCAT(DISTINCT file SEPARATOR ','),
       name from file_tbl 
       as ft join name_tble 
       as nt on ft.email = nt.email 
WHERE 1 
GROUP BY nt.email