Update SQL with two tables in Oracle

sql oracle sql-update ora-00933
Soner Gönül picture Soner Gönül · Feb 8, 2011 · Viewed 26k times · Source

I have a sql like this

UPDATE A
SET A.TEMSILCI_KOD = 4
FROM S_MUSTERI A, S_TEKLIF B
WHERE A.TEMSILCI_KOD = 9
AND B.BAYI_KOD = 17
AND A.HESAP_NO = B.HESAP_NO

But i getting an error like this

Error starting at line 8 in command:
UPDATE A
SET A.TEMSILCI_KOD = 4
FROM S_MUSTERI A, S_TEKLIF B
WHERE A.TEMSILCI_KOD = 9
AND B.BAYI_KOD = 17
AND A.HESAP_NO = B.HESAP_NO
Error at Command Line:9 Column:22
Error report:
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 -  "SQL command not properly ended"
*Cause:    
*Action:

Where is the ERROR?

Answer

pascal picture pascal · Feb 8, 2011

Maybe something like

UPDATE S_MUSTERI
SET TEMSILCI_KOD = 4
WHERE TEMSILCI_KOD = 9
AND EXISTS (SELECT 1 FROM S_TEKLIF B
WHERE S_MUSTERI.HESAP_NO = B.HESAP_NO
AND B.BAYI_KOD = 17)

Related questions

Oracle ORA-00933: SQL command not properly ended?

I keep getting this error. How do I solve this problem? Error: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended Code: <update id="updateProc" parameterClass="rating"> update rating set rating_title=#rating_title# rating_cont=#rating_cont# …

Read More
Update with self-join

I want to update a table to indicate that some rows are parents of others, so I added a "parentid" column to the table. The following query finds all the parents: SELECT ca1.id, ca2.id FROM contactassociations ca1 JOIN …

Read More
Oracle SQL: Update a table with data from another table

Table 1: id name desc ----------------------- 1 a abc 2 b def 3 c adf Table 2: id name desc ----------------------- 1 x 123 2 y 345 In oracle SQL, how do I run an sql update query that can update Table 1 with Table 2's name and desc using …

Read More