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

La Bealtaine wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On 10 Ott, 16:50, La Bealtaine <73cent... (AT) gmail (DOT) com> wrote:
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