Query on the same table

• • Reply

  14 years ago

  by nour

  saad

  Cairo, Egypt

  Joined 14 years ago

  i have a database for a family consist of one table (have id, name, birthdate, and five codes as an acamption that no one will have more than 5 children) i want to make a query to write name and then it will out its children names if he has and grandchildren names if he has and so on...

      could any one help me i'm desprete

                                   thank u for reading

  Report abuse
• • Reply

  13 years ago

  by addi82

  Aditya Singh

  Lucknow, India

  Joined 14 years ago

  Hi Nour,

  Make alias of table. Then it would treat as two table. Now run your query.

  For ex. Select t1.f1, t1.f2, t2.f1,............... from tablename as t1, tablename as t2 where t1.f1=t2.f1

  Hope this would work. For more clarity send more details about your query.   

  Regards,

  Aditya

  Report abuse