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?
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?