Two tables structure identical, the two completely different query results one column

CodePudding user response:

- syntax is as follows:

Update a
The set a.c ol1=biggest ol1, a.c ol2=biggest ol2
From a, b
Where Anderson, d=b. id

CodePudding user response:

Update a set a.a l=b.a l from a a, the CWB.. The CWB b where Anderson, d=b.i d