.. _2023-07-18-rules---support-for-full-outer-joins_release:

=================================================================================
2023-07-18 - Rules - Support for Full Outer Joins
=================================================================================

Release
==================
*Status: Available*

*Type: App-Features*

*Date: 2023-07-18*

Problem
==================
The Join Tile rule step only checks for LEFT or RIGHT to create an outer join statement, there was no support for FULL (outer join).

Solution
==================
Change the Rule Step Type to support FULL OUTER JOIN when a magician uses the keyword FULL in their join change rule step.

Leverage the Magic
====================================
Use the FULL keyword in the Rule Step to define the join as a FULL OUTER join.

ADI
==================
Yeeha!

The ability to quickly iterate the Rule Step options is one of the AgileData superpowers.

Customer
==================
Kudos!

More Rule Step options, removing the need to write custom code.

Last Refreshed
===========================
*Doc Refreshed: 2024-03-02*