>I am not sure that UNION is the clause I need in this case. Once I "moved" the WHERE clause into JOIN, all works well now.
>Thank you for your suggestion.
>
>>You can use UNION clause in your select, e.g. first part would select your data and second would be a UNION to Parts only (no need to do joins).

Interesting. I would not think, moving where clause to JOIN would work...