re: SQL 201: All about SQL JOINs VIEW POST

FULL DISCUSSION
 

this works like an inner join right?

select e.id, e.name, e.salary,d.id d.dept_no, d.dept_name
from emp e, depts d
where e.dept_no = d.id
and e.name = 'John'

code of conduct - report abuse