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_namemanager_idlocation_id
a table employees:
first_nameemployee_id
and table locations:
location_idcity
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),
innerprefix optional. before 9i, oracle didn't follow ansi rules, , didn't supportjoinsyntax.
Comments
Post a Comment