SEARCH
Your selection did not match any results.
select p.ProductID, p.Productname, p.Available, (select top 1 TypeName from mss_index i inner join mss_types t on i.typeid=t.typeid where t.[sign]='MANUS' and i.ProductID=p.ProductID) Manu, (select top 1 TypeName from mss_index i inner join mss_types t on i.typeid=t.typeid where t.[sign]='DESIGNERS' and i.ProductID=p.ProductID) Designer, (select top 1 ImagePath from msS_Images where ProductID=p.ProductID order by PicOrder,ImageID) as ImagePath, Price, SalePrice from mss_Products p where (Available<4 or Available=5) and exists(select top 1 1 from mss_index where productid=p.productid and typeid=509) order by ProductRank
Back