problem with query

[superman69]

hi i am a beginner at mysql im trying to make a query that determines cousins, nephews,grandparent can somebody help me please in how to do this would appreciate it,

 

this is how my table looks like

 

id

firstname

lastname

gender

dateofbirth

SpouseID

MotherID

FatherID

[NargsBrood]

cousins:

I dont think MySQL is power enough to do this one but give it a try:

select * from [table] where mother_id = ( select id from [same table] where mother_id = (select mother_id from [table] where id = ( select mother_id from [table] where id = [id for person you want cousins of] )))

 

grandmother:

select * from [table] where id = ( select mother_id from [table] where id = ( select mother_id from [table] where id = [id for person you want grandparents of]))

 

 

newphes:

and i dont think MySQL is power enough to do this one either:

select * from [table] where mother_id = ( select id from [table] where mother_id = ( select mother_id from [table] where id = select mother_id from [table] where id = [id for person you'd like newphews of]))

 

 

 

[fenway]

Please read the stickies -- there a link to a dev article of hierarchichal data.