First time working with `SQL`. I have table `Person(personID, name, parentID1, parentID2)`. Parents are included in the table. I have to return table Result(child, parent). If the child has no parents, they are not included. If the child has two parents, the child is listed twice next to each parent.

Exact table I'm working with:

```
CREATE TABLE dbo.[Person]
(
    personID INT NOT NULL PRIMARY KEY,
    name VARCHAR(50),
    parentID1 INT,
    parentID2 INT,
    gender VARCHAR(10)
)

INSERT INTO dbo.Person

SELECT 25, 'Jack', 255, NULL, 'Male'
UNION
SELECT 13, 'Jill', 100, 101, 'Female'
UNION
SELECT 82, 'Adam', NULL, 200, 'Male'
UNION
SELECT 100, 'Jeff', NULL, NULL, 'Male'
UNION
SELECT 101, 'June', NULL, NULL, 'Female'
UNION
SELECT 200, 'Shirley', NULL, NULL, 'Female'
UNION
SELECT 155, 'Alice', 255, NULL, 'Female'
UNION
SELECT 255, 'Tom', NULL, NULL, 'Male'
UNION
SELECT 19, 'Jake', 100,101, 'Male'

```