Can you create a merge table whose component tables exist in other databases? I am able to create merge tables for tables that are in one database but I want to be able to aggregate data from multiple databases. I am using 3.23 but I am migrating to 4.0.5a next week, if that makes a difference. The following is an example of what I am trying to do:
Database Name: cust1 Table Name: logs Database Name: cust2 Table Name: logs Database Name: all CREATE TABLE all.combined_logs ("column defs here") TYPE=MERGE UNION=(cust1.logs, cust2.logs) INSERT_METHOD=NO; Thanks Lou Query, sql --> to defeat the spam filter.... --------------------------------------------------------------------- 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