What I've been doing with the tables is:
Ex:
1. I take M table and inner join with a O table, I run it, and it works.
2. I save it as Mo.
3. I repeat step #1, using table M and table C (table C is a completely different table).
4. I save it as Mc. I run it also, and it works.
(now I actually have only three tables all together because M is the same in step 1. and step 3.)
5. I then combine table Mo and table Mc.

I can't do step #5. When I first ran it, I was allowed to do a right outer join, or a left outer join. But only half the table would show up the other half was either blank, or NULL.

Please help!
If anyone else has solutions I would really like to hear them.
Thanks in advance.