I have the following issue:

There a three entities:

1. Problems
2. Taks
3. Objects

Their relations:

• A Problem knows about its Task.

• A Task knows about its Object.

There are no more relations in between them.

So: A Problem has a Task, and this Task has an Object.

I would like to query the following Problems:

Problems which has a Task, which Task has an Object, WHICH IS NOT PRESENT IN THE DATABASE.

Example:

A Problem has a Task, the Task has an Object with id = 10, but this id = 10 Object is not in the database in the Object Table.

As of right now this is my try:

SELECT * 
FROM Problems 
INNER JOIN Tasks ON Tasks.Id = problems.TaskId AND tasks.objectID
... [MISSING PART HERE? I don't know.]