>Unlike Nadya's solution, your description of the problem makes me immediately think of a UNION. That is, I think of JOIN more in the sense of horizontally combining tables; and UNION in the sense of combining tables vertically.
>
>
>select PkField from Table1;
> UNION select PkFIeld from Table2;
> into cursor Tmp
>
>
>Note that, if you don't specify a DISTINCT clause, duplicates will be eliminated automatically.
>
>It seems to me, however, that Nadya's approach is just as sound, and that you could do it either way. My sample represents my personal preference in this case.
>
Hilmar,
I didn't state my problem properly in the first place. I guess because I could not get my mind around it; I am sure everybody has those moments. But when I started looking into Naomi's suggestions, I realized that the problem is much simpler to solve than I initially thought. So I am all set.
Thank you both for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham