xm32sqldad.txt

来自「软件开发技术与方法」· 文本 代码 · 共 21 行

SELECT
	t.EXAMID,
	t.DESCRIPTION,
	t.COMMENTS,
	q.QUESTIONID,
    q.QUESTTEXT,
    q.COMMENT,
    q.ALLOWMULT,
    c.ID,
    c.CORRECT,
    c.CHOICETEXT 
FROM 
	TEST t ,
	QUESTION q,
	CHOICE c
WHERE 
	( t.EXAMID = q.EXAMID AND q.QUESTIONID = c.QUESTIONID )
ORDER BY
	t.EXAMID,
	q.QUESTIONID,
	c.ID