Ok I appear to have narrowed down the issue. it appears to be the last table I had listed named 'user_account1':
mysql> describe user_account1; +-----------------+--------------+------+-----+------------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+------------+-------+ | id | bigint(20) | | | 0 | | | is_active | varchar(10) | | | | | | last_login | date | | | 0000-00-00 | | | reason | varchar(100) | YES | | NULL | | | term_reason | varchar(100) | YES | | NULL | | | last_login_time | time | | | 00:00:00 | | +-----------------+--------------+------+-----+------------+-------+ 6 rows in set (0.00 sec) When I removed the is_active and user_account1 from the following select statement it is immediate: SELECT userid, nickname, city, state, country, email, sex, birthday, marital_stat, num_children, height, weight, smoke, drink, born_again, image1, is_active FROM users1, user_stats1, user_wants1, user_account1 WHERE sex='m' AND userid=user_stats1.id AND userid=user_wants1.id AND userid=user_account1.id; Id still like to know why, but at least its a huge start. Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
