when using multiple tables, Outerjoin clause enables you to include data that does not match across tables.
What is innerjoin and outerjoin in multiple tables?
- Using the join operator in SQL, it is possible to retrieve data from many tables. The following categories of joins are possible:
- Using the criterion provided in the ON clause, the inner join operator first builds a Cartesian product and then filters the results, deleting any rows from the virtual table that do not satisfy the predicate. The most popular join kind is this one.
- A Cartesian product is first created using an outer join operator (LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN), and the results are then filtered to discover rows in each table that match. The distinction is that after the first filter is applied, every rows from one table are maintained and placed back to the virtual table.
To learn more about multiple tables refer to:
https://brainly.com/question/28167137
#SPJ4
