Posted by Angelos on 12/20/05 16:12

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.

[Back to original message]