Hi,
I have a table STATES

ID NAME
----------------------------
0 AL
1 CA
2 DE
3 WY


and a table ROOTS

NAME MOM_STATE_ID DAD_STATE_ID
-------------------------------------------------------------------------------
John 0 0
Jeff 0 1
Jack 1 2
Jim 3 2


What I need is a query to select Name, Mom_state_name and
Dad_state_name

John AL AL
Jeff AL CA
Jack CA DE
Jim WY DE

I'm sorry fro such a boring question and example: I'm sure there is an
appropriate terminology for that, but I'm not expert in SQL at all

Thanks
Lorenzo