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]
