Never mind, I used the show create table Mailbox results as my create table supermailbox query and it worked.
Thanks!!!! Jeff > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 14, 2003 11:59 AM > To: Jeff McKeon; [EMAIL PROTECTED] > Subject: RE: Data from two tables in one query > > > At 11:50 -0400 10/14/03, Jeff McKeon wrote: > >Ok, created the merge table, now I get this error when I log > into the > >mysql server.... > > > >[snip] > >Didn't find any fields in table 'SuperMailbox' > >Welcome to the MySQL monitor. Commands end with ; or \g. > >Your MySQL connection id is 3903 to server version: 3.23.56 > > > >Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > >mysql> show columns from SuperMailbox; > >ERROR 1016: Can't open file: 'SuperMailbox.MRG'. (errno: 143) > > > >[snip] > > > >Any ideas what I've screwed up now? > > > >Thanks, > > > >Jeff > > Hmmm... > > % perror 143 > Error code 143: Unknown error: 143 > 143 = Conflicting table definitions in sub-tables of MERGE table > > Can you post the results for SHOW CREATE TABLE for the tables > you're trying to merge? > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]