Purchase Solution

isbns from two different tables

Not what you're looking for?

Ask Custom Question

I have a query that starts with the line:

SELECT books.isbn, order_lines.isbn

...why would I want to see 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. Assume the table order_lines only contains books that have actually been ordered.

Purchase this Solution
Solution Summary

The expert examines isbns from two different tables. The sort of query which would be warranted are determined.

Solution Preview

1) You want to use inner join on tables 'books' and 'order_lines'
when you want to get all records from both of tables 'books' and 'order_lines'
where there is a match i.e having same ISBN. If there are rows in 'books' that do not have matches in 'order_lines', those rows (BOOKS records) will not be listed.
So innerjoin will give all the books records that are in both tables 'books' and 'order_lines'
So with the assumption the table "books" contains books that the company stocks. Assume the table order_lines only contains books that have actually been ordered.
the innerjoin query results displaying companystocks books that have been ...

Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

C++ Operators

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

Excel Introductory Quiz

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

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.

Basic Networking Questions

This quiz consists of some basic networking questions.

View More Free Quizzes
Related BrainMass Solutions

  • Outer and Inner Joins in Databases

    You can click on TOOLS and then RELATIONSHIPS in Access to get a visual look at how the two tables are related (the line connecting the tables shows how the primary and foreign key relate between the two tables & the columns that the line connects are

  • 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

  • ACCESS 2000

    Including the table name (as in "SELECT authors.author_name") is completely fine, in fact you'll have to do that when you have two or more tables involved in a query. 2.

  • SQL Query to Join Two Tables

    A query showing the tables linked is this: SELECT * FROM Chart_of_Accounts INNER JOIN Property ON Chart_of_Accounts.Property_ID=Property.Property_ID This will show us all of the rows from the two joined tables where the Property_ID matches.

  • Defining Data Relationships

    Data relationship is a link between the data elements of different entities (i.e. tables). By creating this link between two or more than two tables, we can refer tuples in one entity from another.

  • Discussing the Concept of Normalization

    Normalization usually involves dividing a database into two or more tables and defining relationships between the tables.

  • Types of Join Operations

    The buyer_id column is common to the buyers and sales tables and is used to join these two tables.

  • two tables having a master/detail relationship

    Use two OleDbDataAdapter control instances to get the data from the two respective tables. Generate one DataSet based on the two DataAdapters. Write the necessary statements in the frmMain_Load event handler to populate the DataSet.

  • Data Fields and Tables: The Apartment Management Database System

    Note: Products from a certain category can be bought from more than one supplier. In other words, it is possible for them to purchase 2 computers from 2 different places. Please see the attachment for the tables.

View More Related Solutions