Computed Column and Computed Field
A
1 =demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ")
2 =demo.query("select NAME as STATE, ABBR, CAPITAL, POPULATION from STATES")
3
=A1.derive(A2.select@1(STATE ==A1.STATE):StateInfo)

After adding computed column and computed field, you can find in A3 that the original TSeq has been changed: