下面的方法删除了另一个表中有相同外键的房间和消息，但是如果房间没有消息就不删除。我用的是mysql8和java11。

public void deleteRoom() {
        // TODO Auto-generated method stub
        try {
            PreparedStatement preparedStatement = this.databaseMySQL.getConnection().
                    prepareStatement("DELETE OS_ROOMS, OS_ROOM_MESSAGES FROM OS_ROOMS INNER JOIN OS_ROOM_MESSAGES WHERE OS_ROOMS.ROS_ID = OS_ROOM_MESSAGES.ROM_ROS_ID AND OS_ROOMS.ROS_ID = ?");
            preparedStatement.setInt(1, RoomChatSession.id);
            preparedStatement.executeUpdate();
        } catch (SQLException e) {
            // TODO: handle exception
            e.printStackTrace();
        }
    }

我搜索了delete case，比如这个

"DELETE OS_ROOMS, OS_ROOM_MESSAGES FROM OS_ROOMS INNER JOIN OS_ROOM_MESSAGES WHERE (OS_ROOMS.ROS_ID = OS_ROOM_MESSAGES.ROM_ROS_ID AND OS_ROOMS.ROS_ID = ?) OR (OS_ROOMS_ID = ?)"

'我想删除房间，即使它没有消息，它是可能的使用只对sql命令？