On Tue, 1999-08-31 03:10:30 -0400, sam1600@stripped wrote:
> Comment: I have searched high and low for the answer
> to this with no luck. I cannot believe that I am the
> first to run into it :-)
Well, actually you're not -- and your question has been asked, and
answered, only the day before ...
Quoting Sinisa's answer:
| What you are looking for is not join. Join query joins two tables
| by common attribute and displays result from all of them in a single
| What you are looking for is some form of UNION which is not
| implemented (yet) in MySQL.
A work-around for UNION is to do insert the data from both tables
into a temporary table, using twice INSERT INTO tmp SELECT ...
And then fetch the over-all result from this temporary table.
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7