RE: alternative to intersect in mySQL

2002-04-23 Thread Roger Baklund
* 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

RE: alternative to intersect in mySQL

2002-04-23 Thread Thomas Moore
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

RE: alternative to intersect in mySQL

2002-04-23 Thread Roger Baklund
* 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

RE: alternative to intersect in mySQL

2002-04-23 Thread Thomas Moore
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

Re: alternative to intersect in mySQL

2002-04-23 Thread Aleksandar Bradaric
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