Образовательный проект «SnakeProject» Михаила Козлова

⇒ SQL\T-SQL ⇐

CISCO

Voice(Asterisk\Cisco)

Microsoft

Powershell

Python

FreeBSD and Nix

1С

Общая

WEB Разработка

ORACLE SQL \ JAVA

Мото

Стрельба, пневматика, оружие

Саморазвитие и психология

T-SQL: Join1 - 1я часть.sql

USE Sbase

CREATE TABLE A (X INT)

CREATE TABLE B (X INT)

INSERT A VALUES (1), (2), (2), (3), (3)
INSERT B VALUES (2), (3), (4), (5), (NULL)

SELECT * FROM A
SELECT * FROM B

SELECT 
    A.X AS [X from A]
    ,B.X AS [X from B]
FROM 
    A INNER JOIN B
    ON A.X = B.X
    

SELECT 
    A.X AS [X from A]
    ,B.X AS [X from B]
FROM 
    A LEFT OUTER JOIN B
    ON A.X = B.X
    
    
SELECT 
    B.X AS [X from B]
    ,A.X AS [X from A]
FROM 
    B RIGHT OUTER JOIN A
    ON B.X = A.X
    
SELECT 
    B.X AS [X from B]
    ,A.X AS [X from A]
FROM 
    B FULL OUTER JOIN A
    ON B.X = A.X
    
    
SELECT 
    B.X AS [X from B]
    ,A.X AS [X from A]
FROM 
    B CROSS JOIN A

Видео YouTube: http://www.youtube.com/watch?v=fMcC5jcpw3c

Комментарии пользователей