command error in SQL Query, not sure why?

Question

I'm new to SQL and I'm currently writing a query and I got this error. Any help will be appreciated.

ORA-00933: SQL command not properly ended

My Query below:

CREATE VIEW moscow_paris_overlap(SSN) AS 
    SELECT t1.SSN 
    FROM assign AS T1 
    INNER JOIN assign AS T2 
    ON T1.SSN = T2.SSN 
    WHERE T1.EndYear = T2.StartYear 
    AND T1.CityName = 'Moscow' 
    AND T2.CityName = 'Paris';

    SELECT DISTINCT emp.* FROM emp INNER JOIN moscow_paris_overlap ON emp.SSN = moscow_paris_overlap.SSN;

halfer · Accepted Answer · 2022-09-21 18:36:09Z

2

First, you need to separate the CREATE VIEW from the query which uses it. If you're using SQL*Plus or something similar you can do this by putting a / on a separate line between the two. This will cause the CREATE VIEW to be executed first.

Second, AS can't be used in a FROM or INNER JOIN when defining a table alias. Change the FROM clause in your view creation to FROM ASSIGN T1. Similarly, the INNER JOIN should be INNER JOIN ASSIGN T2.

edited Sep 21, 2022 at 18:36

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Mar 15, 2015 at 22:15

Bob Jarvis - Слава Україні

50.2k10 gold badges81 silver badges119 bronze badges

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

Collectives™ on Stack Overflow

command error in SQL Query, not sure why?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related