On Wednesday, August 20, 2014 6:08:58 AM UTC-7, Hiroyuki Sato wrote:
> Dear members.
>
>
>
> Colud you please tell me how to alias column name with join?
>
>
> departments and employees table has same column: ``name''.
> I would like to join both tables.
> And I would like to rename both columns as dept_name and full_name.
>
>
> I can execute join, but I don't know how to alias both table.
>
>
>
> depts.join_table(:inner, employees, { :dept_id => :id }).all
DB[:departments___depts].
select(:depts__name___dept_name, :emps__name___emp_name).
join(:employees___emps, :dept_id=>:id)
Jeremy
>
>
>
> Sincerely.
>
>
> --
> Hiroyuki Sato.
>
>
>
>
> departments table
>
>
>
> sqlite> select * from departments;
> id|name
> 1|marketing
> 2|sales
>
>
>
>
> employees table.
>
>
> sqlite> select * from employees;
> id|name|dept_id
> 1|alice|2
> 2|bob |2
> 3|carol|1
>
>
>
>
>
> In SQL, I woud like to execute the following.
>
>
>
> select depts.name as dept_name,
> emp.name as full_name
> from departments depts,
> employees emp
> where depts.id = emp.dept_id
>
>
>
> Expect result.
>
>
>
> dept_name |full_name
> sales |alice
> sales |bob
> marketing |carol
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
