> -Original Message-
> From: John R Pierce [mailto:pie...@hogranch.com]
> Sent: Thursday, February 11, 2010 3:01 PM
> To: pgsql-general@postgresql.org
> Subject: Re: help with SQL join
>
> Neil Stlyz wrote:
> > Now... here is the problem I am having... the above SQL query is
> > retri
Neil Stlyz wrote:
Now... here is the problem I am having... the above SQL query is
retrieving results from one table: sales
I have another table called customers with a couple of fields
(customerid, and customername are two of the fields).
I want to join on the customerid in both tables to retri
Hello,
I need help with the an advanced SQL JOIN. I think that I can get this
accomplished with a LEFT JOIN... perhaps some of you may be able to offer
guidance in this... I appreciate any suggestions you may have.
Consider the following SQL statement:
SELECT customerid, count(disctint co