>Hi Naomi,
>Thanks for your suggestions. To answer your qiestions.
>1 - Yes, enginebehavior is set to 7
>2- The IN won't work since I need it from the 4 tables. There are different aliases in front the rdt fields in the where statement. If I can do an IN statement for the 4 aliases, I open to the code for that.
>3 - Please elaborate further. I am interested in your comments.
>thanks for taking the time to help.
>Alp

I think Yuri's code is very close to what I had in mind in my comment.