Cross join的一个问题
SELECT TempTable.ProID, TempTable.ProNumber AS 编号,
TempTable.ChiDescription AS 描述, TempTable.LevelName AS 等级,
dbo.DepotConfig.Num AS 数量
FROM (SELECT dbo.Pro.ProID, dbo.Pro.ProNumber, dbo.Pro.ChiDescription,
dbo.[level].levelid, dbo.[Level].LevelName
FROM dbo.[Level] CROSS JOIN
dbo.Pro) TempTable LEFT OUTER JOIN
dbo.DepotConfig ON TempTable.levelid = dbo.DepotConfig.LevelID AND
TempTable.ProID = dbo.DepotConfig.ProID
这条语句,能不能不用临时表来完成,
我要显示的结果为
ProID编号描述 等级数量
10724F8200 "8 " "厨房水龙头 "二等品200
10725F8203 二等品70
10724F8200 "8 " "厨房水龙头 "三等品300
10725F8203 三等品
10724F8200 "8 " "厨房水龙头 "一等品100
10725F8203 一等品50
当Depoconfig不存ProID和LEVELID相等的纪录时,也显示Pro和LEVEL表的Cross join...
[解决办法]
你的语句有什么问题?
