I created an SQL using a Left Join with resulted in a cartesian join as a result.
The format is
The erroneously placed and (should be an = ) creates a cartesian join. Some other database technology calls a parser error on this.
In the case of the system, it happened in on column in the join condition is a primary key and the other is the lead column of a multi-column index of a primary key