Scala slick left join doesnt work
<p>Im a newbie to Slick. </p>

<p>I would like to get the list of ids from Echo table that DO NOT exist in programs_vw table.</p>

<p>I have written the SQL query which works </p>

<pre><code>SELECT f.`id`
FROM `Full`.`programs_vw` f
LEFT JOIN `FULL`.`Echo` e ON f.`id`=e.`id`
WHERE e.`id` IS NULL
ORDER BY f.`id`;
</code></pre>

<p>I have referred to the examples in <a href="http://slick.lightbend.com/doc/3.0.0/queries.html" rel="nofollow noreferrer">http://slick.lightbend.com/doc/3.0.0/queries.html</a> and wrote this but it doesnt work </p>

<pre><code> val query = for {
      (t, f) &lt;- echoQuery.filter(_.id.isEmpty) join programsVwQuery on(_.id === _.id)
      } yield (f.id)
db.run(query.to[List].result)
</code></pre>