Re: Including null values in a discoverer query

La Bealtaine 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

I don't know how you set it up to exclude them.

SELECT *
FROM <table>;

Returns all records without regard to what is or is not null.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org