Incorrect syntax near the keyword 'INNER'.

Question

Heey all Im getting a  Incorrect syntax near the keyword 'INNER'.  DataTable dtListSearch = SearchEngine .CallCommand_GetDataTable (SELECT * FROM [DO_DrinksIngredients] WHERE LOWER(DrinksIngredientsName) LIKE '% + SearchWord.ToLower() + %' INNER JOIN [DO_Drinks] WHERE LOWER(DrinksName) LIKE '% + SearchWord.ToLower() + %';); Hope someone can help me

Kailash Chandra Behera · Answer

select * from Employees inner join EmployeeTerritories on Employees.EmployeeID=EmployeeTerritories.EmployeeID where Employees.LastName like'd%' and TerritoryID like'01%' if this code helps you please mark it as anwer