Guddu
Guddu

Reputation: 1588

Left Outer Join - ORA-00933: SQL command not properly ended

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

Answers (1)

Craig
Craig

Reputation: 5830

LEFT OUTER should be 2 words, not LEFT_OUTER.

Upvotes: 2

Related Questions