Please Help me(SQL)
I have a table named MEAL which contains a foreign key STU_NUM from
STUDENT table so i want to insert two values into MEAL table using the criteria of STU_NUM.
I have tried this code but it gives me Exception which says:
Failed to insertjava.sql.SQLException[Microsoft]
[ODBC Microsoft Access Driver]Missing semicolon(;)at the end of SQL
statement
String query = "INSERT INTO MEAL(MEAL_REL_MADE,MEAL_AMT_LOADED)VALUE("+
"'" + jtfAmLd.getText().trim() +"'" + "," +
"'" + jtfRM.getText().trim()+ "'" + ") WHERE MEAL.STU_NUM ='" +jtfStNo.getText().trim() + "'";
I'll glad if someone can help me with this kind of error

