left outer join/inner join statement

[teneesh]

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,

[debasisdas]

The first query is a inline view and the view is based on a number of joins.

Refer the person who has developed it because i don't have any idea of your table structure.