Thanks to all who responded. I was able to adapt the techniques expressed (or referred to) here to my particular situation.

Yes. That would be fine. Thanks.

After reading my own post I thought I would narrow the scope of my problem. To get the previous examples I could run:

select a.ID, b.ID

from TABLE1 a cross join TABLE1...