MySQL Inner Join Syntax Error in C#

Anyone know why got syntax error? I think there are no reserve words inside right?

C# Command

cmd.CommandText = "SELECT ordertable._name, ordertable.quantity, food_menu.food_price, beverage_menu.beverage_price" +
                         "FROM ordertable" +
                         "INNER JOIN food_menu ON ordertable._name = food.foodname" +
                         "INNER JOIN beverage_menu ON beverage_menu.beverage_name' = ordertable._name" +
                         "WHERE ordertable.tablenum = '1'";

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘JOIN food_menu ON ordertable._name = food.foodnameINNER JOIN beverage_menu ON be’ at line 1


Source: mysql

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.