DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=2VbWd2F8IMpv5fIgz2UkR3ZBLdiNQAXXfFN3y43MmS3YV+9e6DGWNMhvn8LzzhPVsu4oEvO6Z5j1OLSRc0ERUvUtCpQl+yhzPKnwkc+o2ZcnTqF8r+9/jL/CzImADIdfKSi5PyIFNBTUjNN7atIlLllrWiRD1zePKU8VVoqiLpQ=
	;
Message-ID: <20060629052335.51714.qmail@web31812.mail.mud.yahoo.com>
Date: Wed, 28 Jun 2006 22:23:35 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: SELECT Aggregate
To: Phillip Smith <phillips@weatherbeeta.com.au>, pgsql-sql@postgresql.org
In-Reply-To: <00d001c69b33$bfa13b90$9b0014ac@ITPhil>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

> SELECT      trans_no,
>             customer,
>             date_placed,
>             date_complete,
>             date_printed,
>             ord_type,
>             ord_status,
              select (
                         SUM(sell_price)
                         from soh_product
                         where sales_orders.trans_no = soh_product.soh_num
                      ) as transact_sum,
>             customer_reference,
>             salesman,
>             parent_order,
>             child_order,
>             order_number
> FROM        sales_orders
> WHERE       (trans_no Like '8%' AND order_number Like '8%')
>  OR         (trans_no Like '9%' AND order_number Like '8%')
>  OR         (trans_no Like '8%' AND order_number Like '9%')
>  OR         (trans_no Like '9%' AND order_number Like '9%')
>  AND        (warehouse='M')
>  AND        (date_placed > (current_date + ('12 months ago'::interval)))
> ORDER BY trans_no DESC


I am pretty new to SQL.  But while reading a book written by an author recommended on this list,I
can suggest a possible solution that I've seen.  It might work for your problem. Of course, I
haven't tested anything like this and don't know if PostgreSQL supports it.

Just be sure that trans_no is unique in the returned query.

Regards,

Richard Broersma Jr.