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) |
|
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
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