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 has been ordered):
SELECT books.isbn, order_lines.isbn
FROM books LEFT JOIN order_lines ON books.isbn = order_lines.isbn;
How would you get th...
Creation of Entity-Relationship Diagrams Fleet Truck Maintenance. - Organization Name: Huffman Trucking
Locations: All hub locations
Requester: IT Project Manager
Description of Request: Develop Entity-Relationship Diagrams for Fleet Truck Maintenance.
Background of Request: Smith Consulting developed entities and attributes for Fleet Truck Maintenance but did not develop the database...
Create the keys and relationships between tables for the Driver LOG - Using MS Access, create the keys and relationships between tables for the Driver LOG from the file attached.
ACCESS 2000 - (Note: cut and paste the SQL answers for questions 1 and 2 into a word document.
1. Write the
SELECT
FROM
WHERE
code that will select the row from the authors table in the attached WEEK1_Q1_Q2_ACCESS2000 database that has “twain, mark”
NOTE: You can use:
SELECT *
or
SELECT author_name
or...
Running a Query - 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;