Hi, Paul On Fri, Sep 18, 2020 at 12:34 PM Paul Förster <paul.foerster@xxxxxxxxx> wrote: > > Hi Igor, > > > On 18. Sep, 2020, at 19:29, Igor Korot <ikorot01@xxxxxxxxx> wrote: > > > > Hi, > > Consider following > > > > [code] > > CREATE TABLE X(id INTEGER PRIMARY KEY, field1 char(50), field2 int); > > CREATE TABLE Y(id INTEGER PRIMARY KEY, field1 char, field2 double(10, 2)); > > SELECT X.field1, Y.field2 from X, Y WHERE X.id = Y.id; > > [/code] > > > > Assuming that the SELECT return 10 rows, I want to update X.field1 > > in row 5. > > > > How do I write a WHERE clause in the > > > > [code] > > UPDATE X.field1 SET X.field1 = '<some_string>' WHERE.... > > [/code] > > > > Thank you. > > update x set field1='<some string>' where id=5; How do you know that the row #5 will have an X.id field 5? Thank you. > > Cheers, > Paul
