请教sql语句怎么写？

Question

 

 

 

该怎么输出多个结果？

SELECT  yuangong.Name, waituo.username, waituo.time1,sum(jine)
 FROM yuangong
LEFT JOIN waituo 
ON yuangong.Name=waituo.username where time1 BETWEEN  '2021-4-21' and '2021-6-23'   group by username
ORDER BY sum(jine) desc

Answer 1

select yuangong.name, waituo.username, waituo.time1,sum(jine)
into 结果
from yuangong
left join waituo 
on yuangong.name=waituo.username where time1 between  '2021-4-21' and '2021-6-23'   group by username
order by sum(jine) desc

你的yuangong表格 name  不是Name  而且要插入到新的表格 结果中