> Thank you Martijn.
>
> That worked as intentioned.
>
> I actually didn't know that I could make some clauses in the join
> section.
>
> Now I know.

Well, if you need to apply a WHERE condition ONLY to matching
rows (from the join), you would put it in there, while a normal
WHERE applies to all rows returned from the query.

So in this query, it returns all rows matching the JOIN and the
condition plus all rows of the LEFT OUTER.

Easy, isn't it :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com