Purchase Solution

SQL inner joins and ambiguous field names

Not what you're looking for?

Ask Custom Question

Why wont this query run and how would you write it correctly? Major hint: try and run the query (use the database attached to Week 2's lecture) ...
you'll get an error message that should explain:

SELECT isbn
FROM books INNER JOIN order_lines ON books.isbn = order_lines.isbn;

Attachments
Purchase this Solution
Solution Summary

This solution demonstrates an inner join when the tables involved contain fields with the same name.

Solution Preview

First let's look at the query in more detail:

SELECT isbn
FROM books INNER JOIN order_lines ON books.isbn = order_lines.isbn;

The SELECT clause indicates which field(s) you want included in the result set. The fields are indicated by their name. In this case there is only one requested field and it's "isbn".

The FROM clause indicates which tables we are selecting from. This particular FROM ...

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.

Excel Introductory Quiz

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

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.

Javscript Basics

Quiz on basics of javascript programming language.

C++ Operators

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

View More Free Quizzes
Related BrainMass Solutions

  • SQL Joins and Typical Query Usage.

    501801 SQL Joins and Typical Query Usage. Create the following queries on the ITCO630_A database used in unit 3 and save them all in a file called ITCO630_P5.SQL.

  • Kudler Fine Foods- Complete Database SQL Queries

    In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key.

  • SQL Server Database for Kudler Fine Foods/Service

    In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key.

  • Writing SQL Queries Using a Database and Tables

    - Select the employees' last names and group them by salary within job titles that are grouped into exempt and non-exempt. In Microsoft SQL Server Management Studio, save your SQL statements as .SQL files. Save your SQL output as .RPT files.

  • Write SQL queries using BETWEEN, LIKE and UNION

    247061 Write SQL queries using BETWEEN, LIKE and UNION Using the database and tables from the attached file, write SQL queries using BETWEEN, LIKE and UNION: Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict

  • SQL Database

    Instructions are down below and PLEASE USE SQL SERVER 2008 Use the database and tables from last week's assignment to write SQL queries using Between, Like, and Union: - Write a SQL query that joins two tables in the example database and uses BETWEEN

  • SQL Statements To Run In SQl Server

    94940 SQL Statements To Run In SQl Server Write SQL queries using Between, Like and Union: ? Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection.

  • Access SQL queries

    This includes joins, average values, and row counts.

  • Write SQL queries using Between, Like and Union.

    ) - Write a SQL query that joins two tables and restricts the data based on a single job classification. - Write a SQL query that joins two tables and restricts data based on a specific job title and hire_date that is before a specific date.

  • MS SQL SERVER 2003

    Write a SQL query that joins Customer and Store table in the Kudler database and uses BETWEEN to restrict record selection (use Store Name to restrict the data). 2.

View More Related Solutions