Sql server 假表左连接

深藏阁楼爱情的钟 2022-08-06 11:21 167阅读 0赞

1.

select k1,name1,k2,name2 from(select '2'as k1, 'fan' as name1) as a  
left join  
(select k2,name2 from(select '2'as k2, 'hui' as name2) as b) as c  
on a.k1 = c.k2

2.

SELECT M.TITLE, WEEK1,w1,w2 from(  
SELECT \* FROM(  
 SELECT  
 '前年販売数' AS TITLE,  
 '' AS WEEK1,  
 '' AS WEEK2,  
 '' AS WEEK3,  
 '' AS WEEK4,  
 '' AS WEEK5,  
 '' AS WEEK6,  
 '' AS WEEK7,  
 '' AS WEEK8,  
 '' AS WEEK9,  
 '' AS WEEK10,  
 '' AS WEEK11,  
 '' AS WEEK12,  
 '' AS WEEK13,  
 '' AS WEEK14,  
 '' AS WEEK15,  
 '' AS WEEK16,  
 '' AS WEEK17,  
 '' AS WEEK18,  
 '' AS WEEK19,  
 '' AS WEEK20,  
 '' AS WEEK21,  
 '' AS WEEK22,  
 '' AS WEEK23,  
 '' AS WEEK24,  
 '' AS WEEK25,  
 '' AS WEEK26,  
 '' AS WEEK27,  
 '' AS WEEK28,  
 '' AS WEEK29,  
 '' AS WEEK30,  
 '' AS T1,  
 '' AS T2,  
 '' AS T3,  
 '' AS T4,  
 '' AS T5  
) AS T1  
 UNION ALL  
 SELECT \* FROM(  
 SELECT  
 '当年販売数' AS TITLE,  
 '' AS WEEK1,  
 '' AS WEEK2,  
 '' AS WEEK3,  
 '' AS WEEK4,  
 '' AS WEEK5,  
 '' AS WEEK6,  
 '' AS WEEK7,  
 '' AS WEEK8,  
 '' AS WEEK9,  
 '' AS WEEK10,  
 '' AS WEEK11,  
 '' AS WEEK12,  
 '' AS WEEK13,  
 '' AS WEEK14,  
 '' AS WEEK15,  
 '' AS WEEK16,  
 '' AS WEEK17,  
 '' AS WEEK18,  
 '' AS WEEK19,  
 '' AS WEEK20,  
 '' AS WEEK21,  
 '' AS WEEK22,  
 '' AS WEEK23,  
 '' AS WEEK24,  
 '' AS WEEK25,  
 '' AS WEEK26,  
 '' AS WEEK27,  
 '' AS WEEK28,  
 '' AS WEEK29,  
 '' AS WEEK30,  
 '' AS T1,  
 '' AS T2,  
 '' AS T3,  
 '' AS T4,  
 '' AS T5  
) AS T2  
) as M  
left join  
(  
SELECT TITLE,w1,w2 FROM(  
 SELECT  
 '前年販売数' AS TITLE,  
 '1' AS W1,  
 '2' AS W2  
) AS N  
) AS N1  
on M.TITLE = N1.TITLE

发表评论取消回复

表情：

评论列表（有 0 条评论，167人围观）

还没有评论，来说两句吧...

相关阅读

相关 Sql Server：多表连接查询

查询一天所有的信息： select \(查询内容） from (表名） where (时间)>设定时间 and (时间)<设定时间 select from S

快来打我*/ 2023年06月20日 10:47/ 0 赞/ 11 阅读

相关 sql 左连接数据出现重复

> 目录 > > 一、简化举例 > > 二、查询结果 > > 一、简化举例 > > 1、表aa > > ![20201026202200366.png][] >

分手后的思念是犯贱/ 2022年12月18日 11:58/ 0 赞/ 112 阅读

相关 sql之内连接、左连接、右连接、全连接

直接上例子创建两张表如下所示：表a ![这里写图片描述][20160221211221968] 表b ![这里写图片描述][20160221211253

绝地灬酷狼/ 2022年08月20日 10:10/ 0 赞/ 219 阅读

相关 Sql server 假表左连接

1. select k1,name1,k2,name2 from(select '2'as k1, 'fan' as name1) as a left join (s

深藏阁楼爱情的钟/ 2022年08月06日 11:21/ 0 赞/ 168 阅读

相关 sql之左连接、右连接、全连接

我们介绍了表连接，更确切的说是inner joins內连接。內连接仅选出两张表中互相匹配的记录．因此，这会导致有时我们需要的记录没有包含进来。为更好的理解这个概念，我

╰+攻爆jí腚メ/ 2022年08月03日 23:05/ 0 赞/ 181 阅读

相关 SQL SERVER 自连接、外连接

在数据库test2中新建表fruits、suppliers，并插入几组数据： USE test2 GO BEGIN TRY DROP TABLE fr

梦里梦外;/ 2022年07月24日 12:28/ 0 赞/ 287 阅读

相关 SQL Server连接表

在关系数据库管理系统中，表建立时各数据之间的关系不必确定，常把一个实体的所有信息存放在一个表中。当检索数据时，通过连接操作查询出存放在多个表中的不同实体的信息。连接操作给用户带

我不是女神ヾ/ 2022年03月17日 16:50/ 0 赞/ 207 阅读

相关连接到SQL Server

在本教程中，您将学习如何使用SQL Server Management Studio连接到SQL Server并执行查询。 1. 使用SSMS连接到SQL Server

小鱼儿/ 2022年03月17日 04:06/ 0 赞/ 235 阅读

相关 sql中左连接的作用

注：[https://blog.csdn.net/wang0112233/article/details/78418698][https_blog.csdn.net_wang0

Love The Way You Lie/ 2021年09月24日 02:42/ 0 赞/ 254 阅读

相关 Python操作SQL Server(一)连接SQL server

首先引入操作SQL server的模块，pymssql模块 import pymssql 引入pymssql模块然后创建连接对象创建连接对象

淡淡的烟草味﹌/ 2021年08月29日 21:34/ 0 赞/ 495 阅读