|
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.
Navigation:
[Reply to this message]
|