* Thomas Moore
> The issue has to do with relating a PRODUCT table and ATTRIBUTE table so
> that one product is related to multiple attributes. In the
> shopping cart, I
> want to show multiple select menus. After a user selects all of them, only
> the parts related to those attributes will be dis
10:43 AM
To: MySQL List
Cc: [EMAIL PROTECTED]
Subject: RE: alternative to intersect in mySQL
* Thomas Moore
> > I know that intersect does not work yet with mySQL. I am selecting data
> from
> > two tables. Results of one select
> > would be 1, 2, 3, 4 . Results of other
* Thomas Moore
> > I know that intersect does not work yet with mySQL. I am selecting data
> from
> > two tables. Results of one select
> > would be 1, 2, 3, 4 . Results of other select 1, 2.
>
> > Want to print 1, 2.
>
> > Are there any nice workarounds using PHP or SQL?
[temporary table]
> If
23, 2002 1:08 AM
To: Thomas Moore
Cc: MySQL List
Subject: Re: alternative to intersect in mySQL
Hi,
> I know that intersect does not work yet with mySQL. I am selecting data
from
> two tables. Results of one select
> would be 1, 2, 3, 4 . Results of other select 1, 2.
> Want t
Hi,
> I know that intersect does not work yet with mySQL. I am selecting data from
> two tables. Results of one select
> would be 1, 2, 3, 4 . Results of other select 1, 2.
> Want to print 1, 2.
> Are there any nice workarounds using PHP or SQL?
You could use a temporary table to store the