Mysql语句求助

Question

已知图中的两张表，人员表和模板表，通过语句实现每一个人对应所有的模板？将两个表汇总成一张表，如右图所示

Answer 1

将小白兔的答案改成 insert into select就好了, 当然要保证rst表存在
还有一种是select into 这就保存rst表不存在

insert into rst (`name`, test) SELECT emp.name,test.desc as test FROM emp ,test order by name desc , test.desc desc;

Answer 2

SELECT emp.name,test.desc FROM emp ,test ORDER BY name