mysql - 我想获得相同的行名,但我们想获得依赖数据
问题描述
一个查询输出
"MAO" "5"
"ADA_REGULAR" "1"
"JDA_REGULAR" "1"
"SR_ASST_SRC" "2"
"SUPDT_SRC" "1"
"AO_SRC" "3"
"ADA_SRC" "2"
"DDA_SEEDS" "2"
"JDA_SEEDS" "2"
"ADDDIR_SEEDS" "2"
第二个查询输出
"MAO" "4"
"ADA_REGULAR" "3"
"AO Tech" "3"
"JDA_REGULAR" "3"
我想要这样的输出。
column_name no.of_days no.of_days
"MAO" "5" 4
"ADA_REGULAR" "1" 3
"JDA_REGULAR" "1" 3
"SR_ASST_SRC" "2" 0
"SUPDT_SRC" "1" 0
"AO_SRC" "3" 0
"ADA_SRC" "2" 0
"DDA_SEEDS" "2" 0
"JDA_SEEDS" "2" 0
"ADDDIR_SEEDS" "2" 0
"AO Tech" 0 3
enter code here
解决方案
您可以尝试对输出使用联合以获取所需的所有列名,并将此结果左连接到查询输出以获取第一个和第二个输出的日期
select t1.column_name, ifnull(t2.num_days,0), ifnull(t3.num_days,0)
from (
select column_name
from // your query for output 1
union
select column_name
from // your query for output 2
) t1
left join (
// your query for output 1
select column_name, num_days
from my_table1
) t2 ON t1.column_name = t2.column_name
left join (
// your query for output 2
select column_name, num_days
from my_table1
) t3 ON t1.column_name = t3.column_name
推荐阅读
- bash - 在 Dockerfile 中, RUN /bin/mkdir -p /root/lib/{sh,pl,py,rb} 未能达到预期
- python - 将函数分配给实例的方法
- c - / 操作没有给我结果
- r - R 功能:.Rstudio
- javascript - Javascript - 如何在同一类中的另一个方法中调用方法
- sql - SQL Partitioning, how to select a record in the partitioned group that meets certain criteria?
- c++ - Problem compiling and linking voxelyze library
- maven - Maven build produces a WAR with web.xml only
- python - 如何以最易读的形式格式化货币python
- sql - Databricks SQL - How to get all the rows (more than 1000) in the first run?