It is an assorted information gather change which can be utilized to join information from various sources. It works like UNION All declaration in SQL that is used to join come to fruition plan of two SELECT enunciations.