Sergey,
Thank you. I am trying to avoid using IN because it really slows down my query. The tables have over million records.

What do you think of using 'distinct' as I did? somehow 'distinct csrA.*' does not make a lot of sense to me, as we would usually apply distict on one field on not on the entire record. I used distinct on the entire record because, the structures of Tables A & B being different, the query would return a record from csrA whenever it found a macth in TAbleB, theryby repeating records in csrA. Any suggestions would be appreciated.

Ria