See below
Excuse me to the second row inserted into the first line of KPDXZH LZJG values, statements should how to write?
Diagram to simplify the sample forms, more than the actual table has similar situation, through jyls field to distinguish

CodePudding user response:

How to distinguish which is the first line, which is the second line? Or, according to which (some) field sort?

CodePudding user response:

Update the ls t
The set KPDXZH=(select LZJG from ls where jyls=t.j yls)
Where the exists (select 1 from the ls where jyls=t.j yls)

CodePudding user response:

reference 1st floor selling fruit net reply:

how to distinguish which is the first line, which is the second line? Or, according to which (some) field sort?

By ywlxbm field values for xxyw001 LZJG field numerical insert into ywlxbm=xxyw005 KPDXZH