Merge table not usable

[Shourav De]

I have been trying to create this merge table since yesterday. It gets created but if I try to run some select statements on it, I always get this error:

Error Code : 1168
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist

I am trying to merge 25 tables which follow this schema:

CREATE TABLE `fa_atlga` (
`DeedRecordID` int(11) NOT NULL,
`TaxRecordID` int(11) default NULL,
`CurrentDeedRecordID` int(11) default NULL,
`DateLoaded` datetime NOT NULL,
`RLVendorJobDate` date NOT NULL,

(tons more rows here)

`FIPS` int(9) default NULL,
PRIMARY KEY (`DeedRecordID`),
KEY `FIPS` (`FIPS`),
KEY `UNFORMATTEDAPN` (`UNFORMATTEDAPN`),
KEY `PROPERTYADDRESSZIPCODE` (`PROPERTYADDRESSZIPCODE`),
KEY `TransactionDate` (`TransactionDate`),
KEY `RECORDINGDATE` (`RECORDINGDATE`),
KEY `BATCH` (`BATCHID`,`BATCHSEQ`),
KEY `EXCLUDE` (`Exclude`),
KEY `LockedForPublication` (`LockedForPublication`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

The schema for the merge table is same as above except that Primary Key (DeedRecordID) became just Key(DeedRecordID) and ENGINE=MyISAM DEFAULT CHARSET=latin1 became ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(table_name, tablename).

I have triple checked and all the definitions are same across all tables as well as for the merge table.

Pleasd HELP!