string sql = "select * from TBPHYLAYERS where DATACAT_ID in (select DATACAT_ID from TBDATA_CAT where DATACAT_CODE like (select DATACAT_CODE||'%' from TBDATA_CAT where DATACAT_ID=" + theNodeId + "))";
一个字段匹配查询的SQL语句
最新推荐文章于 2023-01-21 15:02:33 发布