MYSQL-将不相干的两个表合成一行数据展示

囧囧君

已于 2022-09-19 08:52:35 修改

阅读量706

点赞数 3

分类专栏： mysql 文章标签：数据库 mysql sql

于 2022-09-19 08:36:11 首次发布

本文链接：https://blog.csdn.net/qq_30942697/article/details/126926440

版权

mysql 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

MYSQL-将不相干的两个表合成一行数据展示

只是一个思路哈，具体问题具体分析

select 
t1.dayStr as '日期',
t2.user_id as '用户ID',
t2.realName as '用户名'
from 
(
	select v.dayStr from (
		select adddate('1970-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) dayStr from
		 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 
		 7 union select 8 union select 9) t0,
		 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 
		 7 union select 8 union select 9) t1,
		 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 
		 7 union select 8 union select 9) t2,
		 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 
		 7 union select 8 union select 9) t3,
		 (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 
		 7 union select 8 union select 9) t4
	)v where v.dayStr >='2022-09-01' and v.dayStr <='2022-09-07'
) t1,
(
	SELECT
		a.user_id,
		a.realName
	FROM
		sys_user a
	WHERE
		a.realName IN ('测试账号', '黄飞鸿')
) t2;