Thanks John

Your last post did the trick.

Tested in all directions.

Lior

Hi John,

Thanks for the reply.

Yes this is the idea but i can't join the tables as the IDs are not correlated. That's why the inner select i tried to do.

Sorry...