Skip to content

Instantly share code, notes, and snippets.

@shaneis
Created December 7, 2017 13:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shaneis/8e92cd9243687549a8e1a0db595c5206 to your computer and use it in GitHub Desktop.
Save shaneis/8e92cd9243687549a8e1a0db595c5206 to your computer and use it in GitHub Desktop.
Sample tables for Itzik Joins
CREATE TABLE dbo.table1 (
Col1 int NOT NULL
);
CREATE TABLE dbo.table2 (
Col1 int NOT NULL
);
CREATE TABLE dbo.table3 (
Col1 int NOT NULL
);
INSERT INTO dbo.table1 (Col1) VALUES (1), (2), (3), (4), (5), (6);
INSERT INTO dbo.table2 (Col1) VALUES (2), (3), (4), (6);
INSERT INTO dbo.table3 (Col1) VALUES (1), (3), (6);
SELECT * FROM dbo.table1;
SELECT * FROM dbo.table2;
SELECT * FROM dbo.table3;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment