How to make a select statement FROM A TABLE that has two INDEXES?

[Angelos]

Hello,
I have the folowing table:
-----------
| content |
-----------
|id |
|parentId |
|title |
-----------

I want to select all the table records but I want in the ParentColumn to
return the title instead of the ID.

If it was in two different tables I would doit using SELECT * FROM t1,t2
WHERE t1.id = t2.parentId

BUT they are in one table.
Can anyone give me a hint ?

I think it should be reallyt simple but I am stuck.

[Gordon Burditt]

>I have the folowing table:

-----------
| content |
-----------
|id |
|parentId |
|title |
-----------

I want to select all the table records but I want in the ParentColumn to
return the title instead of the ID.

If it was in two different tables I would doit using SELECT * FROM t1,t2
WHERE t1.id = t2.parentId

BUT they are in one table.
Can anyone give me a hint ?

You can join a table to itself (many times, if necessary).
Use an alias name for each instance of the table.

SELECT a.*, b.* FROM tablename a, tablename b
WHERE a.id = b.parentId

Gordon L. Burditt