No sorry that is still incorrect.

Incorrect syntax near '+'.

That is what I initially did too.

Can anybody else perhaps help me out on this one?

Thanks.

R

Yeah I know what you guys mean.

But I had to establish were records from uAccountMovements does not exist in neither uProject nor uUnknownProject that’s why I used the AND keyword.

I...

Hi guys,

Just to update you guys...

I managed to solve this by joining on my primary keys instead.

This is what my query looks like now:

SELECT AM.OracleProjectId

FROM uAccountMovement AM

LEFT OUTER JOIN uProject...

Thanks to both of you for the reply.

Adding the IS NULL did return some records.

What if I want to join a second table to check existence in that table too?

Can...