Which type of JOIN returns all matching rows from both tables, plus all unmatched rows from the left table with NULL values filled in for the right table columns?
Explanation:
A Left Outer Join preserves all records from the left table, matching them with right table records when possible, or inserting NULL values if no match is found.
Explanation:
In SQL pattern matching with the LIKE operator, the underscore (*) represents exactly one single character, while the percent sign (%) matches zero or more characters.
No comments yet. Be the first to start the discussion!