1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
|
DROP TABLE IF EXISTS TQUESTION;
DROP TABLE IF EXISTS RESULTAT;
CREATE TABLE TQUESTION
(
TQ_CLE1 INT,
TQ_CLE2 INT,
TQ_OPEN INT,
TQ_HIGH INT,
TQ_LOW INT,
TQ_CLOSE INT
);
CREATE TABLE RESULTAT
(
TR_CLE1 INT,
TR_CLE2 INT,
TR_OPEN INT,
TR_HIGH INT,
TR_LOW INT,
TR_CLOSE INT
);
INSERT INTO TQUESTION VALUES {
(1,1,100,200,300,500), (1,2,101,201,301,401), (1,3,102,202,302,402), (1,4,103,203,303,403),
(2,1,400,200,300,400), (2,2,101,201,301,401), (2,3,102,202,302,402), (2,4,203,203,303,453),
(3,1,500,200,300,200), (3,2,101,201,301,401), (3,3,102,202,302,402), (3,4,803,203,303,563),
(4,1,700,200,300,800), (4,2,101,201,301,401), (4,3,102,202,302,402), (4,4,503,203,303,783)
};
INSERT INTO RESULTAT
SELECT *
FROM TQUESTION
WHERE TQ_CLE2 = 1;
UPDATE RESULTAT AS TR
SET TR.TR_CLOSE = (SELECT TQ.TQ_CLOSE
FROM TQUESTION AS TQ
WHERE TQ.TQ_CLE1 = TR.TR_CLE1 AND TQ.TQ_CLE2 = 4); |
Partager