Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!ames!apple!motcsd!hpda!hpcupt1!schi
From: schi@hpcupt1.HP.COM (Shan Chi)
Newsgroups: comp.databases
Subject: Re: How do you do this query in SQL?
Message-ID: <5910004@hpcupt1.HP.COM>
Date: 19 May 89 20:18:40 GMT
References: <557@cirrus.stsci.edu>
Organization: Hewlett Packard, Cupertino
Lines: 5

It is strange to me that the result table contains NULL value.
I don't remember that SQL select can generate values that do not
exist in the source tables (except for values returned by aggregation 
functions).  Therefore it might be necessary to do several selects, one
for those who have two cars, one for those who have three cars, and so on.