一个字段匹配查询的SQL语句

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 + "))";