Victor,
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).
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
