Any time
>You are right. I completely missed that I need to include another criteria in the JOIN or in the WHERE. Thank you.
>
>>The result is impossible for the query and data you posted.
>>Most likely there're multiple records with PK=230 in one of tables or both.
>>
--sb--