"Paul DuBois" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]At 19:04 +0200 2/24/04, Lorderon wrote: >Is there a way to make concat 2 tables together without using UNION ? >The tables are EXACTLY SAME, but they sit on 2 different DBs. >And I want to run the SAME where clause on both tables...
What's the problem with using UNION?
It's quite slow, when I have large tables.. Here I got the same tables and I want to run the same where clause, so mabye there's something faster that I can use?
Are your tables indexed?
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
