UNION,INTERSECT,and MINUS work properly only if relations are intersect-compatible,which means that the names of the relation attributes and their data types must be different.

Question

Quizplus · Accepted Answer

UNION, INTERSECT, and MINUS can work properly even if the relations are not intersect-compatible as long as the number and order of the attributes match. The names and data types can be the same in such cases.

UNION,INTERSECT,and MINUS Work Properly Only If Relations Are Intersect-Compatible,which Means