MySQL Forums
Forum List  »  PHP

mysql self join php
Posted by: Leonard Tuljo
Date: May 21, 2010 01:33PM

Ok guys can anyone help me I have two tables:

persons(personid, name, surname, personid, personid, placeid)
places(placeid, nameplace)

In table persons columns parsonid, personid means father, mother. I want to get something like this

ID NAME SURNAME FATHER_NAME FATHER_SURNAME MOTHER_NAME MOTHER_SURNAME PLACE
1 John Smith Peter Smith MARIA SMITH Ny

Options: ReplyQuote


Subject
Written By
Posted
mysql self join php
May 21, 2010 01:33PM
May 21, 2010 02:08PM
May 24, 2010 07:46AM
May 24, 2010 10:20AM
May 26, 2010 02:15AM
May 26, 2010 10:14AM
May 27, 2010 12:47AM
May 27, 2010 09:27AM


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.