What does a 0 state mean? Failed? And a 1 state? Passed?<br /><br />Best,<br />Oliveiros<br /><br /><div
class="gmail_quote">2012/1/14Alok Thakur <span dir="ltr"><<a
href="mailto:alokthakur1987@gmail.com">alokthakur1987@gmail.com</a>></span><br/><blockquote class="gmail_quote"
style="margin:0pt0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Dear All,<br /><br /> I have
twotables one contains details of user and other contains<br /> result. The details are:<br /> 1. UserTable - id, name,
phone<br/> 2. result - id, question_id, user_id, status (0 or 1)<br /><br /> I want the list like this:<br /> User Id
Name Attended Failed Passed<br /><br /> but i could not find the way to do this.<br /><br /> Please help<br
/><spanclass="HOEnZb"><font color="#888888"><br /> --<br /> Sent via pgsql-sql mailing list (<a
href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br/> To make changes to your subscription:<br /><a
href="http://www.postgresql.org/mailpref/pgsql-sql"target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br
/></font></span></blockquote></div><br/>