Union is to select all records from two table but common record only once. Select * from tbemp1UNIONSelect * from tbemp2 Inersect is to select common records...
Topic covered are : WHERE clause in LINQ LEFT JOIN in LINQ INNER JOIN in LINQ GROUP BY in LINQ ORDER BY in LINA