Skip site navigation (1) Skip section navigation (2)

sql query problem

From: Alok Thakur <alokthakur1987(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: sql query problem
Date: 2012-01-14 09:18:17
Message-ID: 5ec02ff4-d24b-4824-8116-5445262a6a61@lr19g2000pbb.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

Responses

pgsql-sql by date

Next:From: Tim LandscheidtDate: 2012-01-15 08:02:27
Subject: Token separation
Previous:From: Gavin FlowerDate: 2012-01-14 08:20:47
Subject: Re: Unable To Modify Table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group