what is the difference between join keyword and inner join keyword in oracle sql? -
this question has answer here:
- difference between join , inner join 7 answers
i can't find documentations on key word join
saw examples on web using it.
i doing experiment in oracle hr
schema, have table departments
:
deparment_name
manager_id
location_id
a table employees
:
first_name
employee_id
and table locations
:
location_id
city
query should return department_name, first_name of manager of department, , city department located.
the code using keyword join
seem return result in comparison using keyword inner join
code join
:
select d.department_name, e.first_name,l.city departments d join employees e on d.manager_id=e.employee_id join locations l on d.location_id=l.location_id
code inner join
:
select d.department_name, e.first_name,l.city departments d inner join employees e on d.manager_id=e.employee_id inner join locations l on d.location_id=l.location_id
is there difference between 2 condition, or happen stumble on situation return same results?
- following 1992 ansi sql reference, inner optional:
query expressions 179 7.5 - joined table
3) if qualified join specified , join type not specified, inner implicit.
- following oracle standards (9i onward),
inner
prefix optional. before 9i, oracle didn't follow ansi rules, , didn't supportjoin
syntax.
Comments
Post a Comment