select Material.ShortName,MP2.Name,Stock.Amount
from Material,MP2,Stock
where Material.Id=Stock.MaterialId and Material.MP2Id *= MP2.Id
from Material,MP2,Stock
where Material.Id=Stock.MaterialId and Material.MP2Id *= MP2.Id
FROM dbo.Material INNER JOIN
dbo.Stock ON dbo.Material.Id = dbo.Stock.MaterialId LEFT OUTER JOIN
dbo.MP2 ON dbo.Material.MP2Id = dbo.MP2.Id
呵呵
Why Not 4_eye_dog ?
是一样的吗?
再说DOG犯了我一个同事的忌讳 :)两种写法是一样的
你用企业管理器看看?