内部联接的ON-子句中的附加“或准则”
||
当“ 0”取决于两列中的任何一列时，正确的方法是（内部）联接两个表？因此，当两列中的任一列等于Table2的一列时，Table1应该联接。
查看以下简化的T-SQL，了解我的意思以及是否以正确的方式完成操作：
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
GO
BEGIN TRANSACTION;
GO
create table #RMA1(
SSN_IN varchar(15),
SSN_OUT varchar(15)
)
create table #RMA2(
SSN_NUMBER varchar(15),
)
INSERT INTO #RMA1 VALUES(\'012590001827977\', \'351600035840752\');
INSERT INTO #RMA1 VALUES(\'332653577440220\', \'351600035804105\');
INSERT INTO #RMA1 VALUES(\'350302031074780\', \'350302031074780\');
INSERT INTO #RMA1 VALUES(\'351649036778024\', \'351806033440194\');
INSERT INTO #RMA2 VALUES(\'012590001827977\');
INSERT INTO #RMA2 VALUES(\'332653577440220\');
INSERT INTO #RMA2 VALUES(\'350302031074780\');
INSERT INTO #RMA2 VALUES(\'351649036778024\');
INSERT INTO #RMA2 VALUES(\'351600035840752\');
INSERT INTO #RMA2 VALUES(\'351600035804106\');
SELECT SSN_IN,SSN_OUT,SSN_NUMBER FROM #RMA1 INNER JOIN
#RMA2 ON (#RMA1.SSN_IN = #RMA2.SSN_NUMBER OR
#RMA1.SSN_Out = #RMA2.SSN_NUMBER)
DROP TABLE #RMA1;
DROP TABLE #RMA2;
GO
COMMIT TRANSACTION;
GO
SSN_IN SSN_OUT SSN_NUMBER
012590001827977 351600035840752 012590001827977
012590001827977 351600035840752 351600035840752
332653577440220 351600035804105 332653577440220
350302031074780 350302031074780 350302031074780
351649036778024 351806033440194 351649036778024
ON
#RM1.SSN_IN
#RM1.SSN_OUT
没有找到相关结果
已邀请:
1 个回复
捕暑句簿姓