I have these two tables; mysql> describe tblClass11; +--------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | RecordID | varchar(6) | YES | | NULL | | | RecordDate | varchar(10) | YES | | NULL | | | CIC | varchar(4) | YES | | NULL | | | Minutes | decimal(12,2) | YES | | NULL | | | FileName | varchar(32) | YES | | NULL | | | RecordNumber | int(11) | YES | | NULL | | | WholeRecord | text | YES | | NULL | | | ReceivedDate | varchar(10) | YES | | NULL | | +--------------+---------------+------+-----+---------+----------------+ 9 rows in set (0.00 sec)
mysql> describe tblClassOthers; +--------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | RecordID | varchar(6) | YES | | NULL | | | RecordDate | varchar(10) | YES | | NULL | | | CIC | varchar(4) | YES | | NULL | | | Minutes | decimal(12,2) | YES | | NULL | | | FileName | varchar(32) | YES | | NULL | | | RecordNumber | int(11) | YES | | NULL | | | WholeRecord | text | YES | | NULL | | | ReceivedDate | varchar(10) | YES | | NULL | | +--------------+---------------+------+-----+---------+----------------+ 9 rows in set (0.00 sec) I attempt to MERGE; mysql> CREATE TABLE tblCross1 (ID INT NOT NULL, -> RecordID VARCHAR(6), -> RecordDate VARCHAR(10), -> Minutes DECIMAL(12,2), -> KEY(ID)) -> TYPE=MERGE -> UNION=(tblClass11, tblClassOthers); Query OK, 0 rows affected (0.01 sec) Then I attempt to query;mysql> select count(*) from tblCross1; ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143) perror 143 143 = Conflicting table definition between MERGE and mapped table Can anyone help with this? Thanks! Jay --------------------------------------------------------------------- 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