Query, join both ways

[asp_learner]

Hi,

I have two queries that I am having trouble joining. there are three options and I don't know why we don't have a forth option. to be able to join both ways. to include all in one query and only those that are equal and to include all in the other query and include those that are equal.
It doesn't allow me to click any other kind of options including referential integrity,etc...
Any suggestions,
Thanks.
Eva

 

[asp_learner]

Thank you very much. You have been so help ful to me since I started using this forum.

I was hoping not to have to do additional queries but I see I have no choice.

Thanks,
Eva