MySQL Forums
Forum List  »  Newbie

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!

Options: ReplyQuote


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.