What does the FULL JOIN operation return?

Only matching rows

All rows from both tables with matches where available

Only rows from the left table

Only rows from the right table

FULL JOIN returns all rows from both tables, with NULLs in places where there is no match.

Strengthen Your Practice with our comprehensive question bank.

Get Expert Advice for Free: Register for Your Free Consultation Now!

Full Name

Phone Number

Select Language

Select Course

Please leave this field empty.