what is the difference between join keyword and inner join keyword in oracle sql? -


this question has answer here:

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?

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 support join syntax.

Comments

Popular posts from this blog

android - getbluetoothservice() called with no bluetoothmanagercallback -

sql - ASP.NET SqlDataSource, like on SelectCommand -

ios - Undefined symbols for architecture armv7: "_OBJC_CLASS_$_SSZipArchive" -