Union Operation ( U ) in Python

The ‘Union’ operation combines two relations without having duplicates.

Let us understand the UNION operation better using some examples.

Consider the following table: 

R1 :    FACULTY-1

Example-1 :  Find the tuples of Dno = 23 or tuples of DNo = 25.

  sDNo = 23  (Faculty-1)  U sDNo = 25  (Faculty-1)

Output :                           

Example-2 :  Find the FNames of Dno = 22 or FNames of DNo = 24.

P FName (sDNo = 22(Faculty-1) ) U P FName (sDNo = 24(Faculty-1) )

 Output :                                       

Note : Here, the FNames from both DNos 22 and 24 are taken.