table union question

Hello,

Suppose I have three tables which are identical (in terms of columns, i.e.. they all have column key and column val).

foo_table
a 1
a 2
a 3
b 1
b 2
b 3

bar_table
x 1
x 2
x 3
z 1
z 2
z 3

What would be the sql statement to produce the ff.

foo_bar_table
b 1
b 2
b 3
x 1
x 2
x 3

Thanks in advance for any help. Received on Fri Oct 01 1999 - 12:35:11 CDT