Hi I have one table called noms like this:
| id | int(11) | | PRI | [NULL] | auto_increment | | reference | varchar(255) | | component | varchar(255) | the relation between reference and component is hierarchical like reference - > component reference -> component I want to have all the items into a recorset with only one query like Select id, reference, component from NOMS where reference = '00004' but i want not only the primary relations, i want all relations. Could somebody help a newbie like me? Thanks a million ______________________________________ Linux Rulez!! Registered Linux User: 230557 La vida es modular. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]