Select all in ecto query

Viewed 31

Here is a raw SQL:

SELECT p.*, u.name
FROM posts p
JOIN users u
ON p.user_id = u.id

How do I translate it into Ecto query?

query = from p in Post,
  join: u in User,
  on: p.user_id == u.id,
  select: {[p], u.name}

Is the code above correct?

1 Answers

Here is an extensive documentation for select/3 syntax.

select: %{p | username: u.name}
Related