merhaba ben siteme arama motoru eklemek istiyorum.Sorgum TexBox tan girilen yaziyi veritabanindaki PRODUCTS,CATEGORIES,SUBCATEGORIES tablolarindaki birtakim verilerin arasindan arama yapmasini istiyorum fakat sorgumda hata var yardimci olursaniz sevinirim.

Select ProductID,ProductName,ProductDescription,UnitPrice,CategoryName,SubCategoryName From PRODUCTS inner join CATEGORIES on PRODUCTS.CategoryID=CATEGORIES.CategoryID inner join SUBCATEGORIES on CATEGORIES.CategoryID=SUBCATEGORIES.CategoryID Where ProductName Like '%" +
Textbox1.Text + "%' or ProductDescription " +"Like '%" + Textbox1.Text + "%' or CategoryName Like '%" +
Textbox1.Text + "%' or SubCategoryName Like '%" +
Textbox1.Text + "%' or UnitPrice Like '%" +
Textbox1.Text + "%' Order By " +"ProductName"

Dene...