Re: Curious SQL question
Date: 3 Jan 2007 09:40:24 -0800
Message-ID: <1167846024.044321.298180_at_h40g2000cwb.googlegroups.com>
Marshall wrote:
> On Jan 3, 6:10 am, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
> >
> > Perhaps a more instructive question would be: How does one identify
> > those customers who bought no products at all?
>
> Heh. Assuming that the definition of "customer" is someone who
> has bought some products, the question of what customers have
> bought no products at all can be answered without actually
> consulting the database; it is a tautology.
But we're talking databases here. Customers are defined by the Customer TABLE, orders or not.
Although, if they started a new field of Quantum Databases, you'd be correct. :)
B.
>
> For the question to make sense, then, that can't be the definition
> of customer. Which brings us back to the question Bob asked.
>
>
> Marshall
Received on Wed Jan 03 2007 - 18:40:24 CET