Re: SQL query; how to make a SELECT field ignore WHERE criteria

On 3 Mar 2005 09:38:06 -0800, jadamson60_at_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