dimanche 28 juin 2015

can i have an alias for the result table of inner join

Can I have an alias of the result of the join of 2 tables? So that I can call the result of the table in its alias name.

SELECT emp_table.Name, dept_table.dept
FROM dept_table
inner join emp_table
on emp_table.dept_id = dept_table.dept_id;

Aucun commentaire:

Enregistrer un commentaire