XmlPackage Exception: Exception=Error in XmlPackage(.RunSql), Package=[skins/Skin_1/XmlPackages/DrSoyProduct.xslt], Msg=[Exception=Incorrect syntax near the keyword 'and'.], Sql=[
select v_ProductMasterView.*,ExtendedPrice.CustomerLevelID,ExtendedPrice.Price, Category.Name AS CategoryName
from v_ProductMasterView with (NOLOCK)
inner join ProductCategory on ProductCategory.ProductID = v_ProductMasterView.ProductID
inner join Category on Category.CategoryID = ProductCategory.CategoryID
left outer join ExtendedPrice with (NOLOCK) on v_ProductMasterView.VariantID=ExtendedPrice.VariantID and ExtendedPrice.CustomerLevelID=0
where v_ProductMasterView.ProductID= and v_ProductMasterView.Deleted=0
order by VariantDisplayOrder
]
|
|
