SELECT Prj_DBName FROM kiyunstm_bq.t_projects 使用这个语句查询所有库名,怎么把这两条加在一起
时间: 2024-04-14 16:29:41 浏览: 12
要将这两个查询语句合并在一起,你可以使用子查询的方式将第一个查询作为第二个查询的一部分。以下是合并后的查询语句示例:
```
SELECT v.Version_No, CONCAT(s.Soft_Name, '-', vtl.VTL_TechStrategy) AS Test_level_name, a.TestItem, a.testType, a.use_cases, b.instance_data,
CONCAT(a.use_cases, '/', b.instance_data) AS cases_instances
FROM (
SELECT Prj_DBName
FROM kiyunstm_bq.t_projects
) AS projects
CROSS JOIN projects.Prj_DBName AS database_name
INNER JOIN database_name.t_softlist AS s ON s.TreeUid = v.TreeUid
INNER JOIN database_name.t_testversion AS v ON v.TreeUid = s.TreeUid
INNER JOIN database_name.t_versiontotestlevel AS vtl ON vtl.Version_Uid = v.Version_Uid
LEFT JOIN database_name.view_soft_testreqcanbuildusecase AS qcan ON qcan.VTL_Uid = vtl.VTL_Uid
LEFT JOIN (
SELECT qcan.TestItem, qcan.testType, COUNT(us.TreeUid) AS use_cases
FROM database_name.view_soft_testreqcanbuildusecase AS qcan
INNER JOIN database_name.t_usecase AS us ON us.TreeUid = qcan.ReqTreeUid
GROUP BY qcan.TestType
) AS a ON a.TestItem = qcan.TestItem
LEFT JOIN (
SELECT qcan.TestItem, qcan.testType, COUNT(uci.UC_Uid) AS instance_data
FROM database_name.view_soft_testreqcanbuildusecase AS qcan
INNER JOIN database_name.t_usecase AS us ON us.TreeUid = qcan.ReqTreeUid
INNER JOIN database_name.t_ucinstances AS uci ON uci.UC_Uid = us.UC_Uid
GROUP BY qcan.TestType
) AS b ON b.testType = a.testType
GROUP BY Test_level_name, a.TestType;
```
这个查询语句将第一个查询作为子查询,使用`CROSS JOIN`将其结果与第二个查询中的库名进行组合。然后,将库名用作表名的一部分,以实现在不同库中查询的效果。请确保将`kiyunstm_bq.t_projects`替换为实际的表名和库名。