以第一次查询的结果作为第二次查询的条件 SELECT * FROM sh_direct_mapping WHERE csite_id = (SELECT csite_id FROM devices WHERE dev_code = 16030036);