3、
(1)
SELECT *
FROM S
WHERE A=10;
(2)
SELECT A,B
FROM S
(3)
SELECT A,B,S.C,S.D,E,F
FROM S,T
WHERE S.C=T.C AND S.D=T.D;
(4)
SELECT A,B,S.C,S.D,E,F
FROM S,T
WHERE S.C=T.C;
(5)
SELECT A,B,S.C,S.D,E,F
FROM S,T
WHERE S.A<T.E;
(6)
SELECT S.C,S.D,T.*
FROM S,T;
4、
CREATE TABLE S
(
SNO VARCHAR(20),
SNAME VARCHAR(20),
STATU VARCHAR(20),
CITY VARCHAR(20)
);
CREATE TABLE P
(
PNO VARCHAR(20),
PNAME VARCHAR(20),
COLOR VARCHAR(20),
PWEIGHT VARCHAR(20)
);
CREATE TABLE J
(
JNO VARCHAR(20),
JNAME VARCHAR(20),
CITY VARCHAR(20)
);
CREATE TABLE SPJ
(
SNO VARCHAR(20),
PNO VARCHAR(20)