一个关于left outer join的问题

Question

感觉t2中的值没有带出来，全是NULL.

Answer 1

哦，你这个貌似要用right join

Answer 2

加了isnull：SELECT     TOP (100) PERCENT t1.Fdate, t1.FCheckFlag, t1.FHookFlag, t1.FCostID, t1.FTrade, 
           t1.FBillNo, t1.FDeptIDt1, t1.FEmpIDt1, t1.FCurrencyID, 
                      t1.FRSCBillInterIDt, t1.Fmodel, t1.Fauxqty,
                       t1.Fauxprice, t2.Fauxprice AS FCostPrice, 
                       t1.F_Amount - t1.FTaxAmount AS FTaxAmount, 
                      t1.Fauxqty * isnull(t2.Fauxprice,0) AS FCostamount, 
                      (t1.F_Amount - t1.FTaxAmount) - t1.Fauxqty * isnull(t2.Fauxprice,0) AS FProfit, 
                      t1.FSourceBillNo, t1.FOrderBillNo, 
                      t2.FOrderEntryID
FROM         AIS20110927142957.dbo.vwICBill_43 AS t1 LEFT OUTER JOIN
                      AIS20110927142957.dbo.vwICBill_8 AS t2 ON t2.FbillNo = t1.FSourceBillNo AND t2.Fmodel = t1.Fmodel AND t2.FOrderBillNo = t1.FSourceBillNo AND 
                      t2.FOrderEntryID = t1.ForderEntryID
                      

Answer 3

连接条件定位不准确，lz检查一下on后面的条件是否OK