D. Romanski D. Romanski - 7 months ago 75
SQL Question

SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended"

I have looked through this site and cannot find a similar scenario. I am trying to run the following code

SELECT st.storeid, s.noofitems
FROM salestrnsaction AS st, soldvia AS s
WHERE st.tid = s.tid
ORDER BY noofitems ASC;


and am still receiving the 'SQL command not properly ended' error.

More specifically, this is the message I am receiving.

SELECT st.storeid, s.noofitems
FROM salestrnsaction AS st, soldvia AS s
WHERE st.tid = s.tid
ORDER BY noofitems ASC
Error at Command Line : 287 Column : 22
Error report -
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 - "SQL command not properly ended"
*Cause:
*Action:


Thanks.

Answer

You are using ORACLE right?Using AS in alias in FROM Clause is not valid in Oracle. Please refrain from using AS in giving aliases to tables.

Just write the alias after the table.

SELECT st.storeid, s.noofitems
FROM salestrnsaction st, soldvia s
WHERE st.tid = s.tid
ORDER BY s.noofitems ASC;