计算列
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)

添加计算列后,A1中可以看到原序表被改变: