-1

I have two tables: 

   AudiTable
Id    Audi_cod   status      marke1
1         011      mid        Null
2         022      mid        Null
3         033      mid        Null


     RenoTable
Id         Model    marke2
1           N1        R1
2           N2        R2
3           N3        R3

I have this query: 

 UPDATE AudiTable
        INNER JOIN RenoTable ON AudiTable.Id = RenoTable.Id
        SET status = 'good', AudiTable.marke1=RenoTable.marke2
        WHERE RenoTable.Model = N3 and AudiTable.Audi_cod=011

How do I take a value from one row and put it in a different row?

Colin 't Hart
  • 9,323
  • 15
  • 35
  • 43
tery
  • 7
  • 6

1 Answers1

0

Using Oracle

MERGE INTO AudiTable
USING 
(
  SELECT
    id,
    marke2,
    model
  FROM RenoTable
) TA ON (TA.ID = AudiTable.id)
WHEN MATCHED THEN UPDATE 
    SET AudiTable.STATUS = 'good',AudiTable.MARKE1=TA.MARKE2 
    where TA.MODEL ='N3' and AudiTable.audi_cod=033;

Source: How to update a table from a another table

user3145731
  • 1