If you have MySQL 4, you can use a UNION.
Otherwise you'll need a second table, because what you want is not
a join, but a concatenation of result sets.
At 12:47 -0500 5/6/02, Jay Blanchard wrote:
Here is a puzzler for SQL jockies on a Monday afternoon. I have 2 tables,
each with what may or may
[snip]
If you have MySQL 4, you can use a UNION.
Otherwise you'll need a second table, because what you want is not
a join, but a concatenation of result sets.
[snip]
Don't have 4.0 yet, probably going to wait until a production release comes
out. So if I need a second table I will have to do
On 6 May 2002, at 13:06, Jay Blanchard wrote:
[snip]
If you have MySQL 4, you can use a UNION.
Otherwise you'll need a second table, because what you want is not
a join, but a concatenation of result sets.
[snip]
Don't have 4.0 yet, probably going to wait until a production release comes
[snip]
If you have MySQL 4, you can use a UNION.
Otherwise you'll need a second table, because what you want is not
a join, but a concatenation of result sets.
[snip]
Don't have 4.0 yet, probably going to wait until a production release
comes
out. So if I need a second table I will have to