Video Using Outer Joins. Using Full Outer Joins 304. I dont understand the concept of a left outer join a right outer join or indeed why we need to use a join at all.
A JOIN is a SQL instruction in the FROM clause of your query that is used to identify the tables you. We use the SQL OUTER JOIN to match rows between tables. This free video tutorial will walk you step-by-step through the process.
Using Left Outer Joins 230.
We have the following three types of SQL OUTER JOINS. Merging two data sets using SQL or SQL tools can be accomplished through JOINS. The SQL for the join in the diagram above is. The WHERE clause is applied to this intermediate result and eliminates all but the row that has X13.