On Fri, Jul 07, 2000 at 11:44:30AM +0200, Patrick Jacquot wrote:
[snip]
>
> usually many-to-many relationships are handled by a third table, like this:
>
> create table items (item_id,...)
> create table customers (customer_id, ...)
> create table orders (customer_id, item_id, quantity_orderered
John wrote:
> Hello. I'm trying to do a select here that i have looked at from many
> angles and cannot find a solution too. My main problem, (i believe) is
> that it is trying to create a many to many relationship. I would be
> grateful if anyone knew a way around this.
>
> Here's my predicam
On Thu, 6 Jul 2000, Jan Wieck wrote:
> IMHO the correct suggestion. Just want to underline it.
>
> A list of purchases is usually a subset of another relation.
> Remember, RDBMS means RELATIONAL Database Management System!
> So if you setup your tables with a relational angle
Brett W. McCoy wrote:
> On Thu, 6 Jul 2000, John wrote:
>
> > I would like to get the id's where the customer has purchased an item of a
> > specific type.
> >
> > Problem A: most people order more than one item at a time.
> > So the 'items' field is a colon delimitted text field containing t
John wrote:
>
> Hello. I'm trying to do a select here that i have looked at from many
> angles and cannot find a solution too. My main problem, (i believe) is
> that it is trying to create a many to many relationship. I would be
> grateful if anyone knew a way around this.
>
I believe that y
On Thu, 6 Jul 2000, John wrote:
> I would like to get the id's where the customer has purchased an item of a
> specific type.
>
> Problem A: most people order more than one item at a time.
> So the 'items' field is a colon delimitted text field containing the
>skus of the purchased item
Hello. I'm trying to do a select here that i have looked at from many
angles and cannot find a solution too. My main problem, (i believe) is
that it is trying to create a many to many relationship. I would be
grateful if anyone knew a way around this.
Here's my predicamint.
I have a database f
