Dear, I am trying to provide you as much details as possible.
answer` ( `id` int(10) NOT NULL AUTO_INCREMENT, `question_id` int(10) NOT NULL, `user_id` int(10) NOT NULL, `answer` int(10) NOT NULL, -> `status` tinyint(1) NOT NULL, --> Status will be 0 or 1 means wrong or right answer `date` datetime NOT NULL, PRIMARY KEY (`quiz_result_id`) ) user` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `user` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `user_email` varchar(255) NOT NULL, `user_gender` varchar(255) NOT NULL, `refrence` varchar(255) NOT NULL, `join_date` varchar(255) NOT NULL, `status` tinyint(1) NOT NULL, `banned` tinyint(1) NOT NULL, PRIMARY KEY (`user_id`) ) Now I want the report like this: UserID UserName Attended(questions) Wrong Correct 1 A On Jan 16, 3:49 am, misa.si...@gmail.com (Misa Simic) wrote: > It seems question is not clear... > > I could not determine what should be in column Attended, and based on > what should define passed/failed > > But quick tip would be > > SELECT name, CASE status WHEN 1 THEN 'Passed' ELSE 'Failed' END FROM > UserTable INNER JOIN result ON UserTable.id = result.user_id > > Sent from my Windows Phone > From: Alok Thakur > Sent: 15/01/2012 22:08 > To: pgsql-...@postgresql.org > Subject: [SQL] sql query problem > 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-...@postgresql.org) > To make changes to your > subscription:http://www.postgresql.org/mailpref/pgsql-sql > > -- > Sent via pgsql-sql mailing list (pgsql-...@postgresql.org) > To make changes to your > subscription:http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
