Hi,
I have 2 tables : one children are the names of children
the other parents which can be father, mother
The relationship is on ChidlID

I need to create only one table which would have : children.name, parents.mothername, parents.fathername.

What would be the SQL SELECT statement that would do the job to get both parents from the same table?

Thanks in advance.
Raymond Larche