Re: Curious SQL question

From: Brian Tkatch <Maxwell_Smart_at_ThePentagon.com>
Date: 3 Jan 2007 09:40:24 -0800
Message-ID: <1167846024.044321.298180@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. :)

>
> 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 - 11:40:24 CST