I have two tables, **Friend** (F) and **Likes** (L). **Friend** represents pairs of students (ID1, ID2) who are friends. Friendship is mutual, so if (1510, 1381) is in the **Friend** table, so is (1381, 1510). **Likes** stands for pairs of students ID1 who likes students ID2. Liking someone however is not necessarily reciprocal, so if (1381, 1510) is in the **Likes** table, there is no guarantee that (1510, 1381) is also present. 

This is the SQL code to generate both tables:

```
create table Friend(ID1 int, ID2 int);
create table Likes(ID1 int, ID2 int);

insert into Friend values (1510, 1381);
insert into Friend values (1501, 1247);
insert into Friend values (1468, 1641);
insert into Friend values (1641, 1468);
insert into Friend values (1101, 1641);
insert into Friend values (1247, 1911);
insert into Friend values (1641, 1101);
insert into Friend values (1247, 1501);
insert into Friend values (1911, 1247);
insert into Friend values (1381, 1510);
insert into Friend select ID2, ID1 from Friend;

insert into Likes values(1689, 1709);
insert into Likes values(1911, 1247);
insert into Likes values(1641, 1468);
insert into Likes values(1316, 1304);
insert into Likes values(1501, 1934);

```

I want to get pairs (ID1, ID2) in table **Likes** which are NOT included in table **Friend**. The desired output would be this one:

```
ID1     ID2
1689    1709
1316    1304
1501    1934

```

I have just got rid of pairs (1911, 1247) and (1641, 1468).

My quick try:

```
SELECT DISTINCT *
FROM Likes L, Friend F
WHERE L.ID1 <> F.ID1 AND L.ID1 <> F.ID2 AND L.ID2 <> F.ID1 AND L.ID2 <> F.ID2

```

Which query would give me the desired output? Any idea? Thx.