嵌套sql就正常写就行了啊,不用sql函数了
sql("FRDemo","select zd from table where zd in(select zd from where zd='xxx')",1,1)