Alternate for INTERSECT in mysql 4.1.15

[bzb]

hi ALL,
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..... !
Also, is there any version of mysql which allows the usage of INTERSECT ?


Thank you !

bzb...

[pbmods]

Heya, bzb. Welcome to TSDN!

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`));
 

[bzb]

Heya, bzb. Welcome to TSDN!



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`));
 

----------

hi pbmods,

Thank you - will try with this...

bzb...

[bzb]

----------

hi pbmods,

Thank you - will try with this...

bzb...

=#=#==#=#==#=#==#=#==#=#=

hi pbmods,

I solved the problem by using SELF JOIN and INNER JOIN in the same query.
Thanks.


bzb...