我在sheet1中有下表。
Project| Resource Name | Line Manager
----------------------------------
2345 David Peter
2345 Tam Peter
2345 Richard Peter
2358 Russell Adam
Sheet2有下表
Project| Month |Revenue
-----------------------
2345 Jan 10000
2345 Feb 15000
2358 Jan 8000
2358 Feb 12000
如何在sheet2中获得以下结果
Project| Month| Revenue| Resource|Name Line Manager
------------------------------------------------
2345 Jan 10000 David Peter
2345 Jan 10000 Tam Peter
2345 Jan 10000 Richard Peter
2345 Feb 15000 David Peter
2345 Feb 15000 Tam Peter
2345 Feb 15000 Richard Peter
2358 Jan 8000 Russell Adam
2358 Feb 12000 Russell Adam
最佳答案
怎么样：
select s1.*, s2.* from sheet1 s1 join sheet2 s2 on s2.project=s1.project
关于sql - 将数据从一个表合并到另一个表中的多个级别，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/43069879/