Hi,

Anyone knows what this error mean: ERROR 1114: The table 'SQL16a36b_0' is full? I got it when I used the following query (either inside my Java program or
directly inside the MySQL environment on UNIX: SELECT distinct MainLPPartners.SSN,SubLPPartners.Partner,SubLPPartners.Exercise from MainLPPartners,SubLPPartners where MainLPPartners.SSN!=SubLPPartners.Partner and MainLPPartners.Exercise=SubLPPartners.Exercise and MainLPPartners.GroupId=SubLPPartners.GroupId order by MainLPPartners.SSN

Here is a little more info on the tables I am accessing: each table has 1920
rows of records and their data dictionaries are: mysql> describe MainLPPartners; +----------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+---------------------+------+-----+---------+-------+ | SSN | varchar(255) | YES | | NULL | | | Exercise | tinyint(2) unsigned | YES | | NULL | | | GroupId | tinyint(5) unsigned | YES | | NULL | | +----------+---------------------+------+-----+---------+-------+ mysql> describe SubLPPartners; +----------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+---------------------+------+-----+---------+-------+ | Partner | varchar(255) | YES | | NULL | | | Exercise | tinyint(2) unsigned | YES | | NULL | | | GroupId | tinyint(5) unsigned | YES | | NULL | | +----------+---------------------+------+-----+---------+-------+

Thanks.

Anh