Looking for a good SQL statement.... (I need some help)

[Victor Reus]

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.