Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <18157186.post@talk.nabble.com>
Date: Fri, 27 Jun 2008 08:06:18 -0700 (PDT)
From: Yun Chie <flavour12345@gmail.com>
To: derby-user@db.apache.org
Subject: need help with distinct results
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


Hi all,

I have the following statement (very roughly):

SELECT DISTINCT Customer.Customer_UID, Sales.Sales_UID FROM Customers, Sales
...
INTERSECT 
SELECT DISTINCT Customer.Customer_UID, Sales.Sales_UID FROM Customers, Sales
...

I just need to know what's the right syntax to retrieve only the distinct
results, as,  the above statement retrieve also duplicates, in other words,
what is in derby the right syntax for the following statement:

SELECT Customer.Customer_UID, Sales.Sales_UID (
(SELECT DISTINCT Customer.Customer_UID, Sales.Sales_UID FROM Customers,
Sales ...)
INTERSECT 
(SELECT DISTINCT Customer.Customer_UID, Sales.Sales_UID FROM Customers,
Sales ...)
)

thanks for your help.
-- 
View this message in context: http://www.nabble.com/need-help-with-distinct-results-tp18157186p18157186.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.