SQL & PL/SQL

Hi All,

I am trying to split a single row into more rows

At the moment my query returns:

But it needs to look like this:

From the above you can see that in the first query, both phone parents phone numbers are returned in a single record. I want to split up record so that the parents phone numbers appear as different records.

My query looks like this at the moment:

select

Student_Number,

LastFirst,

motherdayphone,

fatherdayphone

from students

Thanks for any assistance!!