Purchase Solution

Difference between JOIN, equiJOIN, outer JOIN using example

Not what you're looking for?

Ask Custom Question

List the rows in each of the joined tables. Use the small database shown in Figure Q3.5 to illustrate the difference between a natural JOIN, an equiJOlN, and an outer JOIN.

(See attached file for data)

Attachments
Purchase this Solution
Solution Summary

This solution provides the following for a database: natural JOIN, an equiJOIN, and an outer JOIN.

Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

C# variables and classes

This quiz contains questions about C# classes and variables.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

View More Free Quizzes
Related BrainMass Solutions

  • Types of Join Operations

    There are three types of joins: inner joins, outer joins, and cross joins. Additionally, you can join more than two tables by using a series of joins within a SELECT statement, or you can join a table to itself by using a self-join. 1.

  • Outer and Inner Joins in Databases

    Perform a Left Outer Join using tables BOOKS and ORDER_LINES.

  • single table manipulation

    One difference between single table manipulation and table join manipulation B.

  • SQL query

    The needed query is: List the EmployeeID, LastName, and FirstName of all employees who did not take an order between March 1 and March 7, 1997. USe an outer join. You must include the condition on OrderDate in the ON clause of the outer join.

  • Query Results - RIGHT Outer Join

    133167 Query Results - RIGHT Outer Join Using the week 2 lecture database, if you wanted to see all the isbns from the books table and any matching isbns from the order_lines table, you'd want to do an outer join as such (because not every book stocked

  • Write sql statement using join

    (the "answer" is Reagan and Washington) HINT: An easy way to approach this: do an OUTER JOIN (also using "IS NULL") between the employee table and the degree table to figure out who doesnt have a degree.

  • isbns from two different tables

    What sort of query would warrant that - an inner join or an outer join? Assume the table "books" contains books that the company stocks.

  • Subquery and Join

    Hence we combine the outer join with a NULL test in the WHERE clause to reproduce the result set without using a sub-query.

  • Summarizing query and explaining functions and grouping

    There are several formats (INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN, OUTER is usually optional SELECT Customers.CustomerName, Sales.CustomerID, Sum(Sales.Amount) As Total FROM Sales INNER JOIN Customers ON Customers.CustomerID = Sales.CustomerID

View More Related Solutions