прикольный join / Microsoft SQL Server / Sql.ru

with t as ( select distinct CS_PKKEY from dbo.tbl_Costs where CS_SVKEY = 3 and CS_CODE = 20125 )
select * from dbo.Turlist innwer join t on TL_KEY = t.CS_PKKEY

with t as ( select distinct CS_PKKEY from dbo.tbl_Costs where CS_SVKEY = 3 and CS_CODE = 20125 )
select * from dbo.Turlist innwer join t on TL_KEY = t.CS_PKKEY

with t as ( select distinct CS_PKKEY from dbo.tbl_Costs where CS_SVKEY = 3 and CS_CODE = 20125 )
select * from dbo.Turlist innwer join t on TL_KEY = t.CS_PKKEY

dbo.Turlist as innwer [inner] join

select 1a from dbo   
. -- привет
spt_monitor 
count

with t as ( select distinct CS_PKKEY from dbo.tbl_Costs where CS_SVKEY = 3 and CS_CODE = 20125 )
select * from dbo.Turlist innwer join t on TL_KEY = t.CS_PKKEY

with t as ( select distinct CS_PKKEY from dbo.tbl_Costs where CS_SVKEY = 3 and CS_CODE = 20125 )
select * from dbo.Turlist innwer join t on TL_KEY = t.CS_PKKEY

on (????.)TL_KEY = t.CS_PKKEY

прикольный join [new]
aleks222 Member Откуда: Сообщений: 923	Случайно наколотил inner join с ошибкой в слове inner. А оно работает! Что за чудеса?!! Диалект эпохи динозавров? Microsoft SQL Server 2012 (SP2-GDR) (KB3194719) - 11.0.5388.0 (X64) Sep 23 2016 16:56:29 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor) with t as ( select distinct CS_PKKEY from dbo.tbl_Costs where CS_SVKEY = 3 and CS_CODE = 20125 ) select * from dbo.Turlist innwer join t on TL_KEY = t.CS_PKKEY (строк обработано: 4)
25 июн 19, 10:43 [21914622] Ответить \| Цитировать Сообщить модератору

Re: прикольный join [new]
Shakill Member Откуда: мск Сообщений: 1880	вообще парсер позволяет всякое ) select 1a from dbo . -- привет spt_monitor count
25 июн 19, 12:07 [21914724] Ответить \| Цитировать Сообщить модератору

Добро пожаловать в форум, Guest >> Войти \| Регистрация \| Поиск \| Правила \|			В избранное \| Подписаться
Все форумы / Microsoft SQL Server