SQL Server 2012マルチテーブル接続クエリー機能インスタンスコード

くだらないことは言わないで、直接みんなにコードを貼って、具体的なコードは以下の通りです.

--            (X*Y)
SELECT *
FROM  Student
    cross Join dbo.ClassInfo 
--      
SELECT *
FROM  Student , ClassInfo 
--     (Inner     )
SELECT *
FROM  Student
    JOIN dbo.ClassInfo ON dbo.Student.Class = dbo.ClassInfo.ID;
-- Inner Join
SELECT *
FROM  Student
    INNER JOIN dbo.ClassInfo ON dbo.Student.Class = dbo.ClassInfo.ID;
   -- on   ，       ，        
   -- on   ，     ，           
SELECT *
FROM  Student
    INNER JOIN dbo.ClassInfo ON dbo.Student.Class = dbo.ClassInfo.ID
    AND dbo.Student.Class IN (1,2) --   Student       
--     (           )
SELECT *
FROM  Student
    INNER JOIN dbo.ClassInfo ON dbo.Student.Class <> dbo.ClassInfo.ID;
--     Class     Class    
SELECT T1.* ,T2.ClassName FROM dbo.ClassInfo AS T1
    INNER JOIN dbo.ClassInfo AS T2 ON T1.PID=T2.ID
-- Left Join
SELECT *
FROM  Student
    Left JOIN dbo.ClassInfo ON dbo.Student.Class = dbo.ClassInfo.ID;
-- Right Join
SELECT *
FROM  Student
    RIGHT  JOIN dbo.ClassInfo ON dbo.Student.Class = dbo.ClassInfo.ID;
--     
SELECT *
FROM  Student
    FULL OUTER JOIN dbo.ClassInfo ON dbo.Student.Class = dbo.ClassInfo.ID;
--            ：
--    ，on       ，      
--    ，      ，on        ，    NULL
--Union     
SELECT StuID,StuName,StuEnName,StuAge,StuBirthday
FROM  Student WHERE StuID<=2
UNION
SELECT StuID,StuName,StuEnName,StuAge,StuBirthday
FROM dbo.Student WHERE StuID>2
--Union    
SELECT StuSex
FROM  Student WHERE StuID<=2
UNION
SELECT StuSex
FROM dbo.Student WHERE StuID>2
--Union     
SELECT StuSex
FROM  Student WHERE StuID<=2
UNION ALL
SELECT StuSex
FROM dbo.Student WHERE StuID>2
--Except   ,  
SELECT StuID,StuName,StuEnName,StuAge,StuBirthday
FROM  Student
Except
SELECT StuID,StuName,StuEnName,StuAge,StuBirthday
FROM dbo.Student WHERE StuID<=2
--Intersect   
SELECT StuID,StuName,StuEnName,StuAge,StuBirthday
FROM  Student WHERE StuID>=2
Except
SELECT StuID,StuName,StuEnName,StuAge,StuBirthday
FROM dbo.Student WHERE StuID<=3

以上述べたのは小編が皆さんに紹介したSQL Server 2012多表接続照会機能の実例コードで、皆さんに役に立つことを望んでいます.もし皆さんが何か疑問があれば、私にメッセージを送ってください.小編はすぐに皆さんに返事します.