sqlserver查詢我入庫的最后三次的價格，已做好一個物料的查詢但我想一次同時查出所有物料并導出到表格 select distinct top 3 ddate 入庫日期,cInvCode 存貨編碼, iorisum/iQuantity 含稅單價 from RdRecords01 left join rdrecord01 on RdRecord01.id=RdRecords01.ID where cInvCode= 'M0000040' and ddate<'2019-04-30 00:00:00.000' order by ddate desc ;select distinct top 3 ddate 入庫日期,cInvCode 存貨編碼, iorisum/iQuantity 含稅單價 from RdRecords01 left join rdrecord01 on RdRecord01.id=RdRecords01.ID where cInvCode= 'M0000118' and ddate<'2019-04-30 00:00:00.000' order by ddate desc ; select distinct top 3 ddate 入庫日期,cInvCode 存貨編碼, iorisum/iQuantity 含稅單價 from RdRecords01 left join rdrecord01 on RdRecord01.id=RdRecords01.ID where cInvCode= 'M0000209' and ddate<'2019-04-30 00:00:00.000' order by ddate desc ;這種的cInvCode物料編碼我有一個表格，我想根據我的物料編碼表上的所有物料，查出最后三次的入庫價格，上面這樣寫就是查出的是三個表。怎么能根據物料編碼合并到一張表上，并顯示價格呢？