hi,
does anyone know any mysql workarounds for the intersect command? apparently, mysql still doesn't support this command so I can't use "select * from table where job='clerk' intersect select * from table where job='salesman'".
if anyone has come across this problem and has a solution for mysql, please post it. thanks.
you can read my earlier post for full details: <!-- m --><a class="postlink" href="http://www.phpbuilder.com/forum/read.php3?num=5&id=4861&loc=0&thread=4861">http://www.phpbuilder.com/forum/read.ph ... hread=4861</a><!-- m -->
does anyone know any mysql workarounds for the intersect command? apparently, mysql still doesn't support this command so I can't use "select * from table where job='clerk' intersect select * from table where job='salesman'".
if anyone has come across this problem and has a solution for mysql, please post it. thanks.
you can read my earlier post for full details: <!-- m --><a class="postlink" href="http://www.phpbuilder.com/forum/read.php3?num=5&id=4861&loc=0&thread=4861">http://www.phpbuilder.com/forum/read.ph ... hread=4861</a><!-- m -->