What are the different types of Join available in Astera Centerprise?

There are four types of Join available in Astera Centerprise: Inner, Left Outer, Right Outer and Full Outer.

Inner – returns records that records that have matching values in both tables

Left Outer - returns all records from the left table, and the matched records from the right table

Right Outer - returns all records from the right table, and the matched records from the left table

Full Outer – same as Inner Join, but unmatched records from either record set are returned, and null values are written for the unmatched record in the other record set.