MySQL Server Forum - Re: I need help with selecting from 2 identical tables in 2 separate

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: I need help with selecting from 2 identical tables in 2 separate

Bill Karwin

2005-11-18, 8:23 pm

phillip.s.powell@gmail.com wrote:
> Data and structure copying from the 3.23.58 platform to the 4.0.17
> platform is successful!
>
> Now I have another problem: the query itself. How do I merge the 2
> tables together into a new table?

You should be able to use the UNION queries suggested earlier in this
thread. That was the point of copying the data to the server with the
newer version of MySQL, wasn't it?

Regards,
Bill K.

Sponsored Links