What is wrong with this sql code? [message #652617] |
Tue, 14 June 2016 15:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/4d0900debfcb4cec85457bd6db4d86a1?s=64&d=mm&r=g) |
anticristo
Messages: 1 Registered: June 2016
|
Junior Member |
|
|
Hi!
I am trying to learn Oracle. I come from Access. The below code triggers the "Command not properly ended" error". What's is wrong with this? Thanks
UPDATE MUNICIPALITY A
SET A.COUNTY_ID = B.COUNTY_ID
FROM MUNICIPALITY A
INNER JOIN XLSMUNICIPALITIES2 B
ON A.MUNICIPALITY_TYPE_ID = B.MUNICIPALITY_TYPE_ID AND A.MUNICIPALITY_NAME = B.MUNICIPALITY_NAME
WHERE A.COUNTY_ID IS NULL
|
|
|
|
|
|