Re: Union question

From: <sybrandb_at_hccnet.nl>
Date: Wed, 08 Oct 2008 23:51:58 +0200
Message-ID: <joaqe4toig6plul7i3k9lnn1dodsmpjijt@4ax.com>


On Wed, 8 Oct 2008 12:34:03 -0700 (PDT), artmerar_at_yahoo.com wrote:

>> Problem with this query is that if the symbol and company name both
>> meet the criteria, I get duplicates.

Is this an UNION ALL query?
No?
So you WON'T get duplicates, as a SET CAN'T have duplicates! Will you ever learn SQL?
I won't hold my breath!
Apart from that, why do you post everything 2 or 3 times? Are you feeling THAT important?

--
Sybrand Bakker
Senior Oracle DBA
 
Received on Wed Oct 08 2008 - 16:51:58 CDT

Original text of this message