MIDRANGE-L » July 2008

Re: SQL "Left Outer Join," was Re: SQL "Right Outer Join"

Subject: Re: SQL "Left Outer Join," was Re: SQL "Right Outer Join"
From: Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
Date: Tue, 08 Jul 2008 17:35:14 -0500
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

James Lampert wrote:

Is there a way that I can change either my query or my PF, so that the nulls turn into something else before they get to the PF?

Look at COALESCE (as in COALESCE(nullableField, "defaultValue")).

Joe

This thread ...

Re: SQL "Right Outer Join", (continued)
- Re: SQL "Right Outer Join" , vhamberg
- Re: SQL "Right Outer Join" , vhamberg

References:
- RE: SQL "Right Outer Join" , DeLong, Eric
- Re: SQL "Right Outer Join" , James Lampert
- SQL "Left Outer Join," was Re: SQL "Right Outer Join" , James Lampert

Prev by Author: Re: *** ADMIN: EGL vs. <anything> == Off Topic -- REVERSAL
Next by Author: Re: Modernization and multi-member files
Previous by thread: Re: SQL "Left Outer Join," was Re: SQL "Right Outer Join"
Next by thread: SQL "Left Outer Join," was Re: SQL "Right Outer Join"
Index(es):

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact