sql command help

[Trausti Thor Johannsson]

Hello great list,

Here is my table (sort of)

id int
name string
father int
mother int


Father and mother connect to an id.  simple.

So, I have an sql command to find children


select * from person where ( (father=23) or (mother=23) )


I have seen all kinds of strange looking valentina sql, so I was  
wondering if there was a simpler (quicker) way to do this ?  Or  
perhaps a totally different way ?


Thanks,


Trausti