Here I have a code for a view that has been created by a developer on my team. I am trying to use the very same code to create a view for a different formid/quesid. But I cannot figure out how this one starts and ends. can someone please help.
here's the code from the developer.
-
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:
-
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)
Can someone please tell me how the first query works because everytime I try to interpret it and make my own - i end up in circles.
Thank you,
