The SQL JOIN clause is used to mix data from two or more tables inside of a database. A JOIN is a means for combining fields from two tables through the use of values prevalent to each.The keyword OUTER is marked as optional (enclosed in square brackets). With this specific circumstance, no matter whether you specify OUTER or not can make no distin