Hi Terence, I think your problem lies in your SELECT * If you look at the columnheaders below you get category_id twice. I guess you have to specify your columns with aliases.
/Johan
SELECT * FROM ticket_master tm, category_master cm WHERE tm.category_id = cm.category_id; +-----------+-------------+-------------+---------------+ | ticket_id | category_id | category_id | category_name | +-----------+-------------+-------------+---------------+ | 1 | 1 | 1 | test | +-----------+-------------+-------------+---------------+ 1 row in set Thanks
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]