Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stanford.edu!sn-xit-02!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.misc Subject: Re: SQL query; how to make a SELECT field ignore WHERE criteria Date: Thu, 03 Mar 2005 20:26:40 +0100 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: <1109871486.545829.57650@g14g2000cwa.googlegroups.com> X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 18 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:116973 On 3 Mar 2005 09:38:06 -0800, jadamson60@go.com wrote: >Hi > >I have an SQL query that I want to modify so that one of the fields >that I am calling with the SELECT ignores one of the WHERE clause's >(but the others still use it). I was thinking an OUTER JOIN might do it >but it doesn't in this case; the WHERE clause still restricts the >records outputted. What's the best approach to make this column >independant from the specific WHERE clause (there are two comments (--) >to indicate the fields) ? I'm using Oracle 9i: Please clarify for yourself the purpose of the WHERE clause and acknowledge your question is unreasonable. -- Sybrand Bakker, Senior Oracle DBA