A funny thing that I discovered another day (maybe not that funny) that although MySql supports the UNION operation in queries the INTERSECT operation was not being performed.
Even the MINUS operation was happening but not INTERSECT.
Then in one of the posts in another forum I read someone asking when MySql will start supporting INTERSECT.
To me it looks like INTERSECT does not work in MySql. Strange .. Can anybody shed some light on it... and maybe a tell me a work around to INTERSECT... I kinda need to know. Urgently