Left join is the same as left outer join and will show null records on the right side of the join if the join-predicate fails. Inner join or join shows records from both table based on the join-predicate.