Re: Getting similar data

Hi,

If I understand your question correctly, just use a UNION query, like this:

SQL> select * from table1;

THINGY1 NUM1 NUM2
---------- ---------- ----------

apple               2         98
pear                5        100

SQL> select * from table2;

THINGY2 NUMA NUMB
---------- ---------- ----------

gun                20        300
lolly               3        150

SQL> select * from table1
  2 union
  3 select * from table2;

THINGY1 NUM1 NUM2
---------- ---------- ----------

apple               2         98
gun                20        300
lolly               3        150
pear                5        100

SQL> I hope this helps,

Steve Received on Sun Jan 06 2002 - 12:09:28 CST