SQL query joining tables - Oracle

Question

Take an example from sample HR schema. What would be query for finding employees which do not have LOCATION_ID = 1700
I have tried a query using inner join but i don't know how to go further.
The resulting query should something be like

select * from employees
inner join  departments on
    employees.DEPARTMENT_ID=departments.DEPARTMENT_ID
-->  and where departments.location_id != '1700'

Since i am taking HR schema as an example. I would like to add that in my original case location_id is a varchar2.

DevelopmentIsMyPassion · Accepted Answer · 2013-02-12 20:14:08Z

5

I assume you want query in Sql

select * from employees
    inner join  departments on
      employees.DEPARTMENT_ID=departments.DEPARTMENT_ID
where departments.location_id <> 1700

answered Feb 12, 2013 at 20:14

DevelopmentIsMyPassion

3,6014 gold badges36 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dan Bracuk Over a year ago

Oracle supports both != and <> to indicate not equal to. The actual error, that this answer corrects, is that "and where" is not valid syntax for any database. Oh, by the way, even though this works, since department_id is varchar, it should be quoted.

Collectives™ on Stack Overflow

SQL query joining tables - Oracle

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related