Heya, bzb. Welcome to TSDN!
Quote:
Originally Posted by bzb
I have a situation to use INTERSECT in my query, but INTERSECT is not supported in "mysql 4.1.15".
Can anyone explain me how to tackle this problem..... !
The closest thing I could suggest would be to use a JOIN combined with SELECT DISTINCT.
Using the example on
this page, I would probably do something along the lines of:
-
SELECT DISTINCT `Store_Information`.`date` FROM `Store_Information`, `Internet_Sales` WHERE `Store_Information`.`date` = `Internet_Sales`.`date`;
-
Or you could probably just do this:
-
SELECT DISTINCT `date` FROM (`Store_Information` LEFT JOIN `Internet_Sales` USING(`date`));
-
