表TF_MoneyList
MoneyNum Money
FK-2008-02-29-0001 50
FK-2008-02-29-0002 50表TF_MoneyListDetail
ID MoneyNum DepotID
1 FK-2008-02-29-0001 140
2 FK-2008-02-29-0001 141
3 FK-2008-02-29-0002 142
4 FK-2008-02-29-0002 143表TD_InDepotDetail
DepotID MatName MatAmount
140 文祥E630 40
141 电信电脑(1) 50
142 文祥E630 40
143 电信电脑(1) 50
现想查询FK-2008-02-29-0001 的明细,查询结果如下;请教大家如何写
MoneyNum DepotID MatName MatAmount
FK-2008-02-29-0001 140 文祥E630 40
FK-2008-02-29-0001 141 电信电脑(1) 50
MoneyNum Money
FK-2008-02-29-0001 50
FK-2008-02-29-0002 50表TF_MoneyListDetail
ID MoneyNum DepotID
1 FK-2008-02-29-0001 140
2 FK-2008-02-29-0001 141
3 FK-2008-02-29-0002 142
4 FK-2008-02-29-0002 143表TD_InDepotDetail
DepotID MatName MatAmount
140 文祥E630 40
141 电信电脑(1) 50
142 文祥E630 40
143 电信电脑(1) 50
现想查询FK-2008-02-29-0001 的明细,查询结果如下;请教大家如何写
MoneyNum DepotID MatName MatAmount
FK-2008-02-29-0001 140 文祥E630 40
FK-2008-02-29-0001 141 电信电脑(1) 50
left join TD_InDepotDetail as B on A.DepotID=B.DepotID
from TF_MoneyListDetail as A
left join TD_InDepotDetail as B on A.DepotID = B.DepotID
where A.moneynum = 'FK-2008-02-29-0001'