Re: Including null values in a discoverer query

On 10 Ott, 16:50, La Bealtaine <73cent..._at_gmail.com> wrote:
> A complete noob question, I'm sure, but any help appreciated.
>
> I need a query to return an individuals ID number, with four fields of
> details on them
> Not all of the ID numbers have a corresponding entry in all the four
> fields. So when I set up my query to bring in the first field it
> excludes those that are blank, then if I add the second field it
> excludes blanks again - including removing the entries that have a
> value in the first column, but are null in the second.
>
> So, by the time I've set up the worksheet with all four detail
> columns, I have lost about 95% of the records, as those that have a
> null in any of the four fields are removed.
>
> How do I set up the query to include null values?
>
> Thanks

How many tables are you working with? Provide a description of them. Are you doing a join, a self join or what ? Provide your SQL.

-P Received on Fri Oct 19 2007 - 13:18:46 CEST