I have a table that contains a number of items. Each record has a primary Key and a Foreign Key to itself representing a parent/child relationship. For example:

pkey    fkey    title
1       null    line 1
2       1       line 2
3       1       line 3
4       2       line 4
5       2       line 5
6       4       line 6

etc...
What I have spent a long time trying to figure out is how to construct a SQL Query that will extract the table structure in order preserving all parent/children. That is a parent and all its children in order. the final output should look like a tree structure.

ie (just for show):

line 1
     line 2
          line 4
          line 6
     line 5

It should really be a series of record2 with the pkey i.e.

1
2
4
6
5
etc...

I have tried a number of left joins on the table itself to itself, but this doesn't give me a true representation of the tree. I can't think of any way else to do this, but I'm sure there must be a way. Please help me if you can.

Thanks..