求一Sql语句

[qiule]

表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

[marco08]

select * from TF_MoneyListDetail as A
left join TD_InDepotDetail as B on A.DepotID=B.DepotID

[qiule]

明白了,谢谢

[kelph]

select   A.moneynum,A.depotid,B.matname,B.matamount
   from   TF_MoneyListDetail   as   A
 left   join   TD_InDepotDetail   as   B   on   A.DepotID = B.DepotID
 where A.moneynum = 'FK-2008-02-29-0001'