如图所视,单元格SQL如下:SQL("JDBC7", "select fid,fpid,fname from U_ORGANIZATION where orgtype='1' start with fid ='" + B3 + "' connect by prior fid = fpid", 1) ,给d单元格写sql为:SQL("JDBC7","select case when '"+B3+"' not in (select fpid from U_ORGANIZATION) then fpid else '"+C3+"' end from U_ORGANIZATION where fid ='"+B3+"'",1) 可以解决问题,但是要设置单元格扩展,否则D单元格没法得到值,求教 |
最佳回答 |
||||
0
|
|