What is wrong with this sql code? [message #652617] |
Tue, 14 June 2016 15:14 |
|
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
|
|
|
|
|
|