Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- r1:
- A B C
- -------
- 0 1 3
- 2 1 0
- 1 1 1
- 2 0 3
- CREATE TABLE r1(A INT, B INT, C INT);
- INSERT INTO r1 VALUES(0,1,3);
- INSERT INTO r1 VALUES(2,1,0);
- INSERT INTO r1 VALUES(1,1,1);
- INSERT INTO r1 VALUES(2,0,3);
- r2:
- C D E
- -------
- 2 1 1
- 3 1 2
- 3 1 0
- CREATE TABLE r2 (C INT, D INT, E INT);
- INSERT INTO r2 VALUES(2,1,1);
- INSERT INTO r2 VALUES(3,1,2);
- INSERT INTO r2 VALUES(3,1,0);
- r3
- E F
- ----
- 1 1
- 2 4
- CREATE TABLE r3(E INT, F INT);
- INSERT INTO r3 VALUES(1,1);
- INSERT INTO r3 VALUES(2,4);
- r4
- A B C
- -------
- 4 2 1
- 2 1 0
- 1 1 1
- CREATE TABLE r4 (A INT, B INT, C INT);
- INSERT INTO r4 VALUES(4,2,1);
- INSERT INTO r4 VALUES(2,1,0);
- INSERT INTO r4 VALUES(1,1,1);
- r1: r2: r3: r4:
- A B C C D E E F A B C
- ------- ------- ---- -------
- 0 1 3 2 1 1 1 1 4 2 1
- 2 1 0 3 1 2 2 4 2 1 0
- 1 1 1 3 1 0 1 1 1
- 2 0 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement