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