This type of SQL join returns all rows from both tables as with NULL values where the match condition is not satisfied.