Thanks for all the help!

The left join you advised made sense. The problem is that there are so many other tables to take care of which are related in this...

Yes I thought of the union option and got it to work, just it means making a lot of dummy fields in order for the Union not to complain, as...

Ok one last go, hopefully this will be clear. If not please dont worry and thanks for your help.

Below is a view generated for Donors table. It contains a donorid...

Thanks for the reply but I didnt make myself clear.

Although X and Y both have genID they are two independant tables and no join can happen between them. I need...