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 > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 14, 2003 11:19 AM > To: Jeff McKeon; [EMAIL PROTECTED] > Subject: RE: Data from two tables in one query > > > At 11:14 -0400 10/14/03, Jeff McKeon wrote: > >Paul, > > > >> - Original poster suggests that MERGE tables are not > implemented until > >> 4.0, but this is incorrect. MERGE tables are available as of > >> MySQL 3.23.25. > > > >Very true, I must have misread. Now my question is, when I create a > >merge table, do I have to include every field from the two > tables I'm > >merging or can I just grab the ones I want? > > The former. > http://www.mysql.com/doc/en/MERGE.html -- 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]
