Convertion to Ecto query from sql

Questions / Help
, , ,
1

I have a sql query with a join and NOT EXITS as follows

select name, email, nickname, lastname, firstname, phone 
 from a join b on a.user_id=b.id and a.s_id = 2 where NOT EXISTS
 (
 select c.team_id from c
 where c.s_id = 1
 and c.round_id = 2
 and a.id = c.user_id
 );

I want to convert it into Ecto query… Can some one help me with it?

2 
from a in "a",
  select: [:name, :email, :nickname, :lastname, :firstname, :phone],
  inner_join: b in "b", on: a.user_id = b.id and a.s_id = 2,
  left_join: c in "c", on: c.s_id = 1 and c.round_id = 2 and a.id = c.user_id,
  where: is_nil(c.id)
4 Likes