First: don't ask the same thing twice.
> 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.
Second: specify what you mean with "all relations". Can you
share some sample data and sample output (that is: what
do you expect the query to return).
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL