FULL OUTER JOIN
CREATE TABLE #StamTable
( StamTableStr nvarchar(50) NULL )
INSERT INTO #StamTable (StamTableStr) VALUES ('111')
INSERT INTO #StamTable (StamTableStr) VALUES ('222')
GO
CREATE TABLE #StamTable2
( StamTable2Str nvarchar(50) NULL )
INSERT INTO #StamTable2 (StamTable2Str) VALUES ('111')
INSERT INTO #StamTable2 (StamTable2Str) VALUES ('333')
GO
select *
from #StamTable a FULL OUTER JOIN #StamTable2 b
on a.StamTableStr = b.StamTable2Str
drop table #StamTable
drop table #StamTable2
No comments:
Post a Comment