I have a table \"cars\" like this example:
ID name parent description
1 VOLVO (NULL) Volvo
3 70 2 Volvo S70
6 C 1 Volvo C?
2 S 1 Volvo S?
5 60 2 Volvo S60
4 60 6 Volvo C60
There is a parent/child relationship like this:
Volvo (parent)
-- S (1st level child)
----60 (2nd level child)
----70 (2nd level child)
-- C (1st level child)
----60 (2nd level child)
This is actually the order I also would like to end up with, so:
ID parent
1 (NULL)
2 1
5 2
3 2
6 1
4 6
Can anyone tell me how my SQL query should look like:
SELECT ID, parent FROM cars ORDER BY ????
Or any other solution with UNIONS or JOINS? Thx.
[/b]