A Full Join returns all rows from both tables, including matching and non-matching rows, with null values where data is missing. In contrast, a Right Join returns all rows from the right table and only the matching rows from the left table, filling unmatched left-side values with Null