Why is my SQL Query not working?

See more:

Java

SQL

I am trying to delete from two different tables which are linked by the primary key.

My tables are as follows..

Table Name: StudentCourse

PK: StudentID
StudentName
StudentPassword
CourseCode


Table Name: StudentModuleResult

PK: StudentID
ModuleCode
ResultCode


I have the following function:

public String deleteStudent(String studentid) {
        int noOfUpdates = 0;
        String message = "";
        try {
            String strQuery = "DELETE FROM StudentCourse WHERE StudentID = " + studentid
                            + " DELETE FROM StudentModuleResult WHERE StudentID = " + studentid;

            PreparedStatement stmt = conn.prepareStatement(strQuery);
            stmt.setString(1, studentid);
            noOfUpdates = stmt.executeUpdate();
        }
        catch (SQLException e) {
            message = "SQL Exception: " + e.getMessage();
        }
        if (message.length() ==0 && noOfUpdates == 0)
            message = "Record was not updated";

        return message;
    }

However I am receiving the following error:

SQL Exception: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'StudentID = 10198765 DELETE FROM StudentModuleResult WHERE StudentID = 10198765'.