求助：mysql中想把两段查询语句整合成一段语句，怎么写

[小白619]

求助：（mysql）想把两段查询语句整合成一段语句，怎么写？语句如下：

/*创建一个新表（CB00000301）将查询的内容导入到新的表格中，在对这些数据进行查询或者其他处理*/
CREATE table CB00000301
as
(SELECT
d.name as 楼栋名称,
c.UnitName AS 单元名称,
c.floorName AS 楼层,
c. NAME AS 房间名称,
a.meterName AS 表名称,
b.meterRegisterNO AS 抄表单号
FROM
meter a
LEFT JOIN meterregister b ON b.meter_id = a.id
LEFT JOIN property c ON a.property_id = c.id
INNER JOIN building d ON c.building_id = d.id
WHERE
b.meterRegisterNO = 'CB00000301'
AND
a.meterState = '1');

/*查询1-1-1001房间是否在此期间中*/
select * from cb00000301 where `房间名称` ='1-1-1001';

[Neo_whl]

select 楼栋名称,单元名称,楼层,房间名称,表名称,抄表单号  from (
SELECT
d.name as 楼栋名称,
c.UnitName AS 单元名称,
c.floorName AS 楼层,
c. NAME AS 房间名称,
a.meterName AS 表名称,
b.meterRegisterNO AS 抄表单号
FROM
meter a
LEFT JOIN meterregister b ON b.meter_id = a.id
LEFT JOIN property c ON a.property_id = c.id
INNER JOIN building d ON c.building_id = d.id
WHERE
b.meterRegisterNO = 'CB00000301'
AND 
a.meterState = '1')t where 房间名称='1-1-1001';