Re: Union question
From: <sybrandb_at_hccnet.nl>
Date: Wed, 08 Oct 2008 23:51:58 +0200
Message-ID: <joaqe4toig6plul7i3k9lnn1dodsmpjijt@4ax.com>
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 DBAReceived on Wed Oct 08 2008 - 16:51:58 CDT