SELECT dbo.instack.型号, dbo.instack.库存数, dbo.instack.ProdB_Name AS 产品族,
dbo.outstack.出库数
FROM dbo.outstack RIGHT OUTER JOIN
dbo.instack ON dbo.outstack.型号 = dbo.instack.型号
上面有两个视图,一个是instack,和outstackinstack是这样的SELECT dbo.Product.Pro_Name AS 型号, COUNT(dbo.Phone.ESN) AS 库存数,
dbo.productbass.ProdB_Name
FROM dbo.Product INNER JOIN
dbo.productbass ON dbo.Product.ProdB_ID = dbo.productbass.ProdB_ID INNER JOIN
dbo.Phone ON dbo.Product.Pro_ID = dbo.Phone.Pro_ID
GROUP BY dbo.Product.Pro_Name, dbo.Phone.Current_Status,
dbo.productbass.ProdB_Name
HAVING (dbo.Phone.Current_Status = N'入库')outstack是这样的SELECT dbo.Product.Pro_Name AS 型号, COUNT(dbo.Phone.ESN) AS 出库数,
dbo.productbass.ProdB_Name AS 产品族
FROM dbo.Product INNER JOIN
dbo.productbass ON dbo.Product.ProdB_ID = dbo.productbass.ProdB_ID INNER JOIN
dbo.Phone ON dbo.Product.Pro_ID = dbo.Phone.Pro_ID
GROUP BY dbo.Product.Pro_Name, dbo.Phone.Current_Status,
dbo.productbass.ProdB_Name
HAVING (dbo.Phone.Current_Status = N'出库')我只想在代码中把他们放在一起SELECT dbo.instack.型号, dbo.instack.库存数, dbo.instack.ProdB_Name AS 产品族,
dbo.outstack.出库数
FROM dbo.outstack RIGHT OUTER JOIN
dbo.instack ON dbo.outstack.型号 = dbo.instack.型号向上面的SELECT dbo.instack.型号, dbo.instack.库存数, dbo.instack.ProdB_Name AS 产品族,
dbo.outstack.出库数
FROM (.......)dbo.outstack RIGHT OUTER JOIN
(......)dbo.instack ON dbo.outstack.型号 = dbo.instack.型号中的"......."一样用outstack视图中的代码来添充(.......).用instack的视图代码来添充后面的(.....).如下SELECT dbo.instack.ProdB_Name AS 产品族, dbo.instack.型号, dbo.instack.库存数,
dbo.outstack.出库数
FROM (SELECT dbo.Product.Pro_Name AS 型号, COUNT(dbo.Phone.ESN) AS 出库数,
dbo.productbass.ProdB_Name AS 产品族
FROM dbo.Product INNER JOIN
dbo.productbass ON dbo.Product.ProdB_ID = dbo.productbass.ProdB_ID INNER JOIN
dbo.Phone ON dbo.Product.Pro_ID = dbo.Phone.Pro_ID
GROUP BY dbo.Product.Pro_Name, dbo.Phone.Current_Status,
dbo.productbass.ProdB_Name
HAVING (dbo.Phone.Current_Status = N'出库'))dbo.outstack RIGHT OUTER JOIN
(SELECT dbo.Product.Pro_Name AS 型号, COUNT(dbo.Phone.ESN) AS 库存数,
dbo.productbass.ProdB_Name
FROM dbo.Product INNER JOIN
dbo.productbass ON dbo.Product.ProdB_ID = dbo.productbass.ProdB_ID INNER JOIN
dbo.Phone ON dbo.Product.Pro_ID = dbo.Phone.Pro_ID
GROUP BY dbo.Product.Pro_Name, dbo.Phone.Current_Status,
dbo.productbass.ProdB_Name
HAVING (dbo.Phone.Current_Status = N'入库'))dbo.instack ON dbo.outstack.型号 = dbo.instack.型号
但为什么会出错呢?!请指教
谢谢!
dbo.outstack.出库数
FROM dbo.outstack RIGHT OUTER JOIN
dbo.instack ON dbo.outstack.型号 = dbo.instack.型号
上面有两个视图,一个是instack,和outstackinstack是这样的SELECT dbo.Product.Pro_Name AS 型号, COUNT(dbo.Phone.ESN) AS 库存数,
dbo.productbass.ProdB_Name
FROM dbo.Product INNER JOIN
dbo.productbass ON dbo.Product.ProdB_ID = dbo.productbass.ProdB_ID INNER JOIN
dbo.Phone ON dbo.Product.Pro_ID = dbo.Phone.Pro_ID
GROUP BY dbo.Product.Pro_Name, dbo.Phone.Current_Status,
dbo.productbass.ProdB_Name
HAVING (dbo.Phone.Current_Status = N'入库')outstack是这样的SELECT dbo.Product.Pro_Name AS 型号, COUNT(dbo.Phone.ESN) AS 出库数,
dbo.productbass.ProdB_Name AS 产品族
FROM dbo.Product INNER JOIN
dbo.productbass ON dbo.Product.ProdB_ID = dbo.productbass.ProdB_ID INNER JOIN
dbo.Phone ON dbo.Product.Pro_ID = dbo.Phone.Pro_ID
GROUP BY dbo.Product.Pro_Name, dbo.Phone.Current_Status,
dbo.productbass.ProdB_Name
HAVING (dbo.Phone.Current_Status = N'出库')我只想在代码中把他们放在一起SELECT dbo.instack.型号, dbo.instack.库存数, dbo.instack.ProdB_Name AS 产品族,
dbo.outstack.出库数
FROM dbo.outstack RIGHT OUTER JOIN
dbo.instack ON dbo.outstack.型号 = dbo.instack.型号向上面的SELECT dbo.instack.型号, dbo.instack.库存数, dbo.instack.ProdB_Name AS 产品族,
dbo.outstack.出库数
FROM (.......)dbo.outstack RIGHT OUTER JOIN
(......)dbo.instack ON dbo.outstack.型号 = dbo.instack.型号中的"......."一样用outstack视图中的代码来添充(.......).用instack的视图代码来添充后面的(.....).如下SELECT dbo.instack.ProdB_Name AS 产品族, dbo.instack.型号, dbo.instack.库存数,
dbo.outstack.出库数
FROM (SELECT dbo.Product.Pro_Name AS 型号, COUNT(dbo.Phone.ESN) AS 出库数,
dbo.productbass.ProdB_Name AS 产品族
FROM dbo.Product INNER JOIN
dbo.productbass ON dbo.Product.ProdB_ID = dbo.productbass.ProdB_ID INNER JOIN
dbo.Phone ON dbo.Product.Pro_ID = dbo.Phone.Pro_ID
GROUP BY dbo.Product.Pro_Name, dbo.Phone.Current_Status,
dbo.productbass.ProdB_Name
HAVING (dbo.Phone.Current_Status = N'出库'))dbo.outstack RIGHT OUTER JOIN
(SELECT dbo.Product.Pro_Name AS 型号, COUNT(dbo.Phone.ESN) AS 库存数,
dbo.productbass.ProdB_Name
FROM dbo.Product INNER JOIN
dbo.productbass ON dbo.Product.ProdB_ID = dbo.productbass.ProdB_ID INNER JOIN
dbo.Phone ON dbo.Product.Pro_ID = dbo.Phone.Pro_ID
GROUP BY dbo.Product.Pro_Name, dbo.Phone.Current_Status,
dbo.productbass.ProdB_Name
HAVING (dbo.Phone.Current_Status = N'入库'))dbo.instack ON dbo.outstack.型号 = dbo.instack.型号
但为什么会出错呢?!请指教
谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货