In MySQL, CROSS JOIN
is used to fetch all records from both the tables, where each row in the result set is the combination from both the tables. This is happens because it does not have the join conditions.
To fetch all records from both the joined tables, use the following syntax:
Parameters:
tablename1 & tablename2: The table name from which you want to fetch records.
col1: The column or field name that will be return.
CROSS JOIN
:
Note:
In the above example, we are fetching all record from both "tblbankheadquartersandaddress" and "tblbankdemataccountcharges" tables using CROSS JOIN
.
You can use MySQL Command Line Client to fetch all records from both tables without having the join conditions.