select ProductName=[Name], ProductNumber, [Description], ListPrice
from [Production].[Product] p
join [Production].[ProductModelProductDescriptionCulture] pmpdc
on p.ProductModelID = pmpdc.ProductModelID
join [Production].[ProductDescription] pd
on pmpdc.ProductDescriptionID = pd.ProductDescriptionID
where patindex( '%off-road%comfortable%', pd.[Description]) > 0
No comments:
Post a Comment