How to join two rows in same table?
Posted by:
sooeydoo
Date: June 16, 2005 12:25PM
Could someone please help me formulate a query for the following function:
I have two rows - heading and body - in one table tiki_articles
While all rows have heading, only some have body. I want to combine those rows that have a body with their corresponding heading rows so that the result is one big heading row with both heading and body content in that order.
The ID is defined by another row called articleId, if it is needed.
Thanks so much for any help!
Subject
Written By
Posted
How to join two rows in same table?
June 16, 2005 12:25PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.