Not sure how other people haven't come across this problem. But mysql doesn't support the INTERSECT statement.
it does not support EXCEPT also.
possible solutions are in: http://stackoverflow.com/questions/2621382/alternative-to-intersect-in-mysql
used in operations.hpp, we should delegate sql-generation for these to Backend, so we can use specific sql for each backend.
Anonymous
You seem to have CSS turned off. Please don't fill out this field.
it does not support EXCEPT also.
possible solutions are in:
http://stackoverflow.com/questions/2621382/alternative-to-intersect-in-mysql
used in operations.hpp, we should delegate sql-generation for these to Backend, so we can use specific sql for each backend.