Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE WA(a nvarchar(5));
- CREATE TABLE NT(a nvarchar(5));
- CREATE TABLE SA(a nvarchar(5));
- CREATE TABLE Q(a nvarchar(5));
- CREATE TABLE NSW(a nvarchar(5));
- CREATE TABLE V(a nvarchar(5));
- CREATE TABLE T(a nvarchar(5));
- INSERT INTO WA values ('red'),('green'),('blue');
- INSERT INTO NT values ('red'),('green'),('blue');
- INSERT INTO SA values ('red'),('green'),('blue');
- INSERT INTO Q values ('red'),('green'),('blue');
- INSERT INTO NSW values ('red'),('green'),('blue');
- INSERT INTO V values ('red'),('green'),('blue');
- INSERT INTO T values ('red'),('green'),('blue');
- SELECT * FROM WA, NT, SA, Q, NSW, V, T
- WHERE WA.a != NT.a and WA.a != SA.a and NT.a != SA.a
- and NT.a != Q.a and SA.a != Q.a and SA.a != NSW.a
- and SA.a != V.a and Q.a != NSW.a and NSW.a != V.a
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement