大家帮帮忙分析一下语句的意思,谢谢!SELECTa.FBatchNo,c.FNameASAuxName,b.FNameASstockName,ISNULL(SUM(a.FQty),0)ASFQty,ISNULL(SUM(a.FSecQty),0)ASFSecQty,0ASFprice,ISNULL(SU...
大家帮帮忙分析一下语句的意思,谢谢!SELECT a.FBatchNo, c.FName AS AuxName, b.FName AS stockName, ISNULL(SUM(a.FQty), 0) AS FQty, ISNULL(SUM(a.FSecQty), 0) AS FSecQty, 0 AS Fprice, ISNULL(SUM(a.FBal), 0) AS FAmount, a.FKFDate, a.FPeriodDate, b.FNumber AS StockNumber, c.FNumber AS AuxNumber, b.FItemID, d.FISKFPeriod FROM T_CC_Inventory a INNER JOIN t_Stock b ON a.FStockID = b.FItemID LEFT OUTER JOIN t_AuxItem c ON a.FAuxPropID = c.FItemID INNER JOIN t_ICItem d ON a.FItemID = d.FItemID WHERE (a.FItemID = 89) AND (a.FQty <> 0) AND (a.FStockID = 86) OR (a.FItemID = 89) AND (a.FStockID = 86) AND (a.FBal <> 0) GROUP BY a.FBatchNo, c.FName, b.FName, a.FKFDate, a.FPeriodDate, b.FNumber, c.FNumber, b.FItemID, d.FISKFPeriod 里面的a.表名 c.表名 b.表名 是什么意思啊? 里面.是什么意思?
展开