Tag Archives: union

[DATABASE] Difference between intersect and union

I have two relations namely PROPERTY and LEASE, see the PROPERTYNO attributes returned from PROPERTY and LEASE respectively: In intersect, tuples which exists in both relations will be displayed removing duplicates. In union, all tuples from property and all tuples … Continue reading

Posted in Database | Tagged , | Leave a comment