** 使用子查询可以关联两张表 ** 以Oracle举例: SELECT * FROM NDMC.ISPACE_CATALOG_INFO WHERE OWNERUSERID = ( SELECT NDUSERID FROM BMSUITEM.T_BMS_USER_ACCOUNT WHERE MSISDN = '13700575981' );