From: teknokrat <teknokrat@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: help with troublesome query
Date: Tue, 15 Jul 2003 14:26:16 +0100
Message-ID: <bf0vdv$3pi$1@localhost.localdomain> (raw)
I have three tables customers which 1-many with requests which is 1-1
with applications. all customers have at least one request but not all
requests have an application.
I want a query to return all the customers and their application data if
they have any ( or else null). So this is like a left join of customers
with applications but I do not want multiple rows of customers UNLESS
they have an application.
thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: teknokrat@yahoo.com
Subject: Re: help with troublesome query
In-Reply-To: <bf0vdv$3pi$1@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox