>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.
Is what you're trying to accomplish is a UNION of the cursors MO and MC? How are you trying to combine these two cursors, and for what purpose?
PS: it's much easier to follow a thread if you "quote" it in your message. You can use the check box at the bottom before you reply, or set it in your user profile.