Reputation: 1588
What is wrong with this query? I just can't get it to execute on a Oracle 11G Database.
SELECT PH.ORD_NBR, PH.TEL_NBR, SM.NAME
FROM ORD_HDR PH
LEFT_OUTER JOIN STORE SM ON SM.COUNTY='1' AND
SM.STORE_ID=PH.STORE_ID WHERE PH.ORD_NBR='777894801' AND ROWNUM<=1
I get this errror
ORA-00933: SQL command not properly ended
Upvotes: 0
Views: 1473