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