asked
Receiving Error Messages in Oracle
Need to provide the employee first and last names who do not have either a blog or a website but I receiving an error message. Any advice on how I should correct this issue. This is what I have been working with: SELECT e.first_name,e.last_name FROM Employee e INNER JOIN Website w ON e.employee_id = w.employee_id INNER JOIN Blog bl ON w.blog_id = bl.blog_id WHERE w.website_url = NULL WHERE bl.blog_url = NULL; Error received: Error starting at line 1 in command: SELECT e.first_name,e.last_name FROM Employee e INNER JOIN Website w ON e.employee_id = w.employee_id INNER JOIN Blog bl ON w.blog_id = bl.blog_id WHERE w.website_url = NULL WHERE bl.blog_url = NULL Error at Command Line:6 Column:1 Error report: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" *Cause: *Action:
You have WHERE twice. You should read about the AND / OR operators: [
http://www.w3schools.com/sql/sql_and_or.asp][1] [1]:
http://www.w3schools.com/sql/sql_and_or.asp
17 People are following this question.
