SQL 联合查询。
如何实现下图的SQL 并能够得出分队里面最大队的数量。比如该例子是最在为7
[解决办法]
用3个视图不行吗？
[解决办法]
select TeamName as 队名,
TeamGoal as 全队任务,
TeamEmployee as 姓名,
EmployeeGoal as 现金任务,
'' AS 已完成
from Assess
order by employeeGoal desc
select TeamEmployee as 姓名,
EmployeeGoal as 现金任务,
'' AS 已完成
from Assess
where TeamName='xxx'
