sql语句...查了什么???

SELECT a.Id, a.ProductBrandName, a.ProductName, a.ProductLength, a.ProductWidth,
a.ProductHeight, b.ProducerNetName, a.Price, c.ProductMeterialName,
d.ProductColorName, e.ProductStyleName, a.CoverallStates, f.MatURL
FROM productinfo a INNER JOIN
ProducerNet b ON a.ProducerNet_Id = b.ProducerNet_Id INNER JOIN
ProductMeterial c ON a.ProductMeterial_Id = c.ProductMeterial_Id INNER JOIN
ProductColor d ON a.ProductColor_Id = d.ProductColor_Id INNER JOIN
ProductStyle e ON a.ProductStyle_Id = e.ProductStyle_Id INNER JOIN
ProductFlash f ON a.Id = f.Id
WHERE (a.ProductBrandName = '"&ProductBrandName&"')
Order By a.CreateTime Desc

引用通告: 我要引用此文章
Tags:
相关日志: