Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.
In SQL:1999, the join of two tables returning only matched rows is an inner join.A Join between two tables that returns the results of the inner join as well as unmatched rows left (or right) tables is a left (or right) outer join.A Join between two tables that returns the results of an inner join as well as the results of a left and right join is a full outer join.
