Postgres Pro
Downloads
Home   >   mailing lists

sql query problem - Mailing list pgsql-sql

From Alok Thakur
Subject sql query problem
Date
Msg-id 5ec02ff4-d24b-4824-8116-5445262a6a61@lr19g2000pbb.googlegroups.com
Whole thread Raw
Responses Re: sql query problem  (Oliveiros <oliveiros.cristina@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Call function with dynamic schema name
Next
From: Oliveiros
Date:
Subject: Re: sql query problem