| 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)
|
添加计算列后，A3计算结果如下：:
