FULL OUTER JOIN is used to fetch all records from LEFT and RIGHT side table. It places NULL where the join condition is not met.
To fetch all records from LEFT and RIGHT side table, use the following syntax:
tablename1 & tablename2: The table name from which you want to fetch records.
col1: The column or field name that will be return.
FULL OUTER JOIN:
In the above example, we are fetching all "banks" and "accountName" fields value from "tblbankheadquartersandaddress" and "accountName" field from "tblbankdemataccountcharges" table using
FULL OUTER JOIN.