有关sql server产品详细信息页面的查询 [英] Query regarding to sql server Product Detail page

问题描述

嗨！
我有从中选择产品的产品页面，它在产品页面上重定向.
加入后我会得到适当的详细信息，但是我有产品功能表.它只有
两个领域.一个是ProductId，另一个是ProductFeatureId

我只想获得具有全部功能的单个产品.

以下是我的查询:

Hi!
I have product page from where i select product and it redirect on product page.
I am get proper details after join but I have on product feature table. It have only
two fields. one is ProductId and other ProductFeatureId

I only want to get a single product with its all feature.

following is my query:

SELECT     p.ProductName, p.Detail, p.StartingDate, p.ClosingDate, p.BidPrice, p.BidIncrement, p.Model, p.ProductImage, p.RegisterNo, p.IsAvailable, p.Status, 
                      c.CityName, com.CompanyName, s.StateName, cn.CountryName
FROM         tblProduct AS p LEFT OUTER JOIN
                      tblCategory AS cat ON p.CategoryId = cat.CategoryId LEFT OUTER JOIN
                      tblCompany AS com ON p.CompanyId = com.CompanyId LEFT OUTER JOIN
                      tblCity AS c ON p.CityId = c.CityId LEFT OUTER JOIN
                      tblState AS s ON c.StateId = s.StateId LEFT OUTER JOIN
                      tblCountry AS cn ON s.CountryId = cn.CountryId

并且这些表仍然联接剩余:

and still these table join remaining:

ProductFeature-------> ProductId,FeatureId
FeatureId     ------->  FeatureId,FeatureName

我如何加入它

How can i join it

推荐答案

SELECT p.ProductName，p.Detail，p.StartingDate，p.ClosingDate，p.BidPrice，p.BidIncrement，p.Model ，p.ProductImage，p.RegisterNo，p.Isavailable，p.Status，
c.CityName，com.CompanyName，s.StateName，cn.CountryName
来自tblProduct AS p，tblCategory AS cat，tblCompany AS com，tblCity AS c，
tblState AS s，tblCountry AS cn INNER JOIN
ON p.CategoryId = cat.CategoryId INNER JOIN
在p.CompanyId = com.CompanyId内部联接
上 ON p.CityId = c.CityId内部联接
ON c.StateId = s.StateId INNER JOIN
开启s.CountryId = cn.CountryId

SELECT p.ProductName, p.Detail, p.StartingDate, p.ClosingDate, p.BidPrice, p.BidIncrement, p.Model, p.ProductImage, p.RegisterNo, p.IsAvailable, p.Status,
c.CityName, com.CompanyName, s.StateName, cn.CountryName
FROM tblProduct AS p,tblCategory AS cat,tblCompany AS com,tblCity AS c,
tblState AS s,tblCountry AS cn INNER JOIN
ON p.CategoryId = cat.CategoryId INNER JOIN
ON p.CompanyId = com.CompanyId INNER JOIN
ON p.CityId = c.CityId INNER JOIN
ON c.StateId = s.StateId INNER JOIN
ON s.CountryId = cn.CountryId

这篇关于有关sql server产品详细信息页面的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！