table union question
From: Jay <mighty_dragon_at_hotmail.com>
Date: Fri, 01 Oct 1999 12:35:11 -0500
Message-ID: <37F4F0CF.7C5BF516_at_hotmail.com>
Hello,
Date: Fri, 01 Oct 1999 12:35:11 -0500
Message-ID: <37F4F0CF.7C5BF516_at_hotmail.com>
Hello,
[Quoted] 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 - 19:35:11 CEST