What does a 0 state mean? Failed? And a 1 state? Passed? Best, Oliveiros
2012/1/14 Alok Thakur <alokthakur1...@gmail.com> > Dear All, > > I have two tables one contains details of user and other contains > result. The details are: > 1. UserTable - id, name, phone > 2. result - id, question_id, user_id, status (0 or 1) > > I want the list like this: > User Id Name Attended Failed Passed > > but i could not find the way to do this. > > Please help > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >