teststmts.sql

CREATE TABLE T1 (K INT,
                 A CHAR(2),
                 Y INT,
                 PRIMARY KEY(K));

INSERT INTO T1 VALUES(1,'ab',20);
INSERT INTO T1 VALUES(2,'xy',15);
INSERT INTO T1 VALUES(3,'ac',19);
INSERT INTO T1 VALUES(4,'ab',100);
INSERT INTO T1 VALUES(5,'rv',100);
INSERT INTO T1 VALUES(6,'xy',12);

CREATE TABLE T2 (K1 INT,
				 K2 CHAR(2),
				 X CHAR(5),
				 Y INT,
				 PRIMARY KEY(K1));

INSERT INTO T2 VALUES (100,'ab','abscd',20);
INSERT INTO T2 VALUES (101,'ac','abscd',346);
INSERT INTO T2 VALUES (102,'rv','dgh',19);
INSERT INTO T2 VALUES (103,'ab','cxcsd',194);
INSERT INTO T2 VALUES (104,'fd','gjhk',100);
INSERT INTO T2 VALUES (105,'xy','hgfza',15);

SELECT * FROM T1;

SELECT A FROM T1;

SELECT * FROM T1 WHERE K = 5;

SELECT K2, Y FROM T2 WHERE K1 > 102;

CREATE TABLE T3(C INT,
                D INT);

SELECT * 
FROM T2 JOIN T1
ON T2.Y = T1.Y;