I have two tables as below: 

```
Highschooler
ID  name         grade
1510    Jordan         9
1689    Gabriel        9
1381    Tiffany        9
1709    Cassandra      9
1101    Haley         10
1782    Andrew        10
1468    Kris          10
1641    Brittany      10
1247    Alexis        11
1316    Austin        11
1911    Gabriel       11
1501    Jessica       11
1304    Jordan        12
1025    John          12
1934    Kyle          12
1661    Logan         12

Friends
ID1 ID2
1689    1709
1709    1689
1782    1709
1911    1247
1247    1468
1641    1468
1316    1304
1501    1934
1934    1501
1025    1101

```

I need to create a table that has the name and grade of people who are friends with each other as given in the "Friends" table. I basically need to look up the name and grade of each ID given in the friends table. 

I have two select statements that look up the name and grade for ID1 and ID2 separately. 

```
select name,grade from highschooler where id IN
(select id1 from friends)

```

and 

```
select name,grade from highschooler where id IN
(select id2 from friends)

```

However, I cannot figure out how to get a table that looks like this:

```
name1 grade1 name2 grade2
Gabriel 9    Cassandra 9

```

I have tried concatanating the two select statements as well as union but neither work for this situation. 

I am new to SQL. Any help is very much appreciated!