What you have described is an "inner join", not a 'distinct union'.
Inner joins of multiple tables are done using the "Query Builder" task in EGuide. Look in the EGuide help under 'joining tables' as the process may vary slightly depending on your version of EGuide.