I have two tables that are exactly alike. What I want to do is fetch the rows from each into one sortable result set. Example:
Table1 ---------------------------------- | Column1 | Column2 | Column 3 | ---------------------------------- | 1 | 2 | 3 | ---------------------------------- | 2 | 7 | 3 | ---------------------------------- Table2 ---------------------------------- | Column1 | Column2 | Column 3 | ---------------------------------- | 6 | 4 | 2 | ---------------------------------- | 6 | 9 | 1 | ---------------------------------- I'm trying to get this: ---------------------------------- | Column1 | Column2 | Column 3 | ---------------------------------- | 1 | 2 | 3 | ---------------------------------- | 2 | 7 | 3 | ---------------------------------- | 6 | 4 | 2 | ---------------------------------- | 6 | 9 | 1 | ---------------------------------- Unfortunately if I use a join I end up with: -------------------------------------------------------------------- | Column1 | Column2 | Column 3 | Column1 | Column2 | Column 3 | -------------------------------------------------------------------- | 1 | 2 | 3 | 6 | 4 | 2 | | 2 | 7 | 3 | 6 | 9 | 1 | -------------------------------------------------------------------- Aside from creating a temporary table and killing the speed of my queries, is there any way to do this? I noticed Mysql 4 has a union function, but I am using 3.23. Also, no it is not possible for me to use one table for the information. Thanks in advance --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
