here's the code from the developer.
Expand|Select|Wrap|Line Numbers
- SELECT a.EvalRecNo, w1.q1, w2.q2, w3.q3, w4.q4, w5.q5, w6.comment
- FROM (SELECT DISTINCT u.EvalRecNo
- FROM dbo.UData AS u INNER JOIN
- dbo.EvalIssue AS e ON u.EvalRecNo = e.RecNo
- WHERE (e.FormNo = 'R507') AND (e.DateComplete IS NOT NULL)) AS a LEFT OUTER JOIN
- (SELECT u.EvalRecNo, u.NumAns AS q1
- FROM dbo.UData AS u INNER JOIN
- dbo.UFormQuestion AS fq ON u.QuesFormID = fq.QuesFormID
- WHERE (fq.QuesID = 858)) AS w1 ON a.EvalRecNo = w1.EvalRecNo LEFT OUTER JOIN
- (SELECT u.EvalRecNo, u.NumAns AS q2
- FROM dbo.UData AS u INNER JOIN
- dbo.UFormQuestion AS fq ON u.QuesFormID = fq.QuesFormID
- WHERE (fq.QuesID = 859)) AS w2 ON a.EvalRecNo = w2.EvalRecNo LEFT OUTER JOIN
- (SELECT u.EvalRecNo, u.NumAns AS q3
- FROM dbo.UData AS u INNER JOIN
- dbo.UFormQuestion AS fq ON u.QuesFormID = fq.QuesFormID
- WHERE (fq.QuesID = 860)) AS w3 ON a.EvalRecNo = w3.EvalRecNo LEFT OUTER JOIN
- (SELECT u.EvalRecNo, u.NumAns AS q4
- FROM dbo.UData AS u INNER JOIN
- dbo.UFormQuestion AS fq ON u.QuesFormID = fq.QuesFormID
- WHERE (fq.QuesID = 861)) AS w4 ON a.EvalRecNo = w4.EvalRecNo LEFT OUTER JOIN
- (SELECT u.EvalRecNo, u.NumAns AS q5
- FROM dbo.UData AS u INNER JOIN
- dbo.UFormQuestion AS fq ON u.QuesFormID = fq.QuesFormID
- WHERE (fq.QuesID = 862)) AS w5 ON a.EvalRecNo = w5.EvalRecNo LEFT OUTER JOIN
- (SELECT u.EvalRecNo, u.TxtAns AS comment
- FROM dbo.UData AS u INNER JOIN
- dbo.UFormQuestion AS fq ON u.QuesFormID = fq.QuesFormID
- WHERE (fq.QuesID = 865)) AS w6 ON a.EvalRecNo = w6.EvalRecNo
I'd like to do the exact same thing with this code:
Expand|Select|Wrap|Line Numbers
- select b.quesid, b.formno, b.questext, d.numans, d.txtans from uquestionbank b, uformquestion f, udata d
- where b.quesid = f.quesid
- and f.quesformid = d.quesformid
- and b.formno = 'R102'
- and f.quesid in (486,519,522)
Thank you,