I have 2 tables Users(Name TEXT) and 'Coffee Breaks'(Person1 TEXT, Person2 TEXT).

I need to write a join that will return all the users a given user hasn't had a Coffee Break with.

I'm attempting to do a left join with IS NULL on the right side.

The db query is completing without error but I am not getting any users in the result. Is the issue with my SQL query string?

SQL:

```
WITH bilateral(p1, p2) AS (SELECT Person1 AS p1, Person2 AS p2 FROM "Coffee Breaks"
   UNION ALL SELECT Person2 AS p1, Person1 AS p2 FROM "Coffee Breaks"
   GROUP BY p1, p2)
SELECT * FROM Users u1, Users u2
   LEFT JOIN bilateral bi ON u1.Name=bi.p1 AND u2.Name=bi.p2
   WHERE bi.p1 IS NULL

```

Sample Data:

```
Users
[
  {
    Name: "Casey"
  },
  {
    Name: "Jake"
  },
  {
    Name: "Mark"
  },
  {
    Name: "Steve"
  }
]

Coffee Breaks
[
  {
    Person1: "Steve",
    Person2: "Casey"
  }
]

```

Server Code:

```
db.neverCoffeed = function(user) {
  const sql = `WITH bilateral(p1, p2) AS (SELECT Person1 AS p1, Person2 AS p2 FROM "Coffee Breaks"
    UNION ALL SELECT Person2 AS p1, Person1 AS p2 FROM "Coffee Breaks"
    GROUP BY p1, p2)
  SELECT * FROM Users u1, Users u2
    LEFT JOIN bilateral bi ON u1.Name=bi.p1 AND u2.Name=bi.p2
    WHERE bi.p1 IS NULL`;
  return new Promise((resolve, reject) => {
    this.run(sql, (err, users) => {
      if (err) {
        reject(err);
      }
      else {
        console.log('users', users)
        resolve(users);
      }
    });
  });
};

```