Re: hierarchical records, I need some help!! ;(

Hi again, > 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). Ok my table noms is like | id | int(11) | | PRI | [NULL] | auto_increment | reference| varchar(255) |

hierarchical records, I need some help!! ;(

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

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

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