Getting similar data

From: Steve Wood <jester98x_at_btinternet.com>
Date: Sun, 6 Jan 2002 16:21:18 +0000 (UTC)
Message-ID: <a19thu$f2f$1@paris.btinternet.com>

Hi all,

I'm fairly new to Oracle, still very much learning the basics, and have hit a problem that I hope someone on this group can help me with.

I have two tables that hold similar data (they do have the same datatypes in the fields I'm trying to return)

Basically I want to be able to return all the data from the matching fields from these tables).

Example
table1
apple 2 98
pear 5 100

table2
gum 20 300
lolly 3 150

I then want to carry out a select that returns apple 2 98
pear 5 100
gum 20 300
lolly 3 150

Thanks,
Steve Received on Sun Jan 06 2002 - 10:21:18 CST