Hello,
Let's say I have 3 unrelated tables.

table1        table2         table3
------        ------         ------
A             RED            JOHN
B             BLUE
C             YELLOW
              ORANGE
              GREEN

I need a query that will return this in one cursor

resultquery
----------------------------
A          RED          JOHN
B          BLUE         (blank)
C          YELLOW       (blank)
(blank)    ORANGE       (blank)
(blank)    GREEN        (blank)

blanks or nulls, whatever.
Thanks a lot,
jfh