Computer Science Homework Solutions
Problem
#133166

Rows from a Query

You can create your own Cartesian product - run this code in the database attached to Lecture Two:

SELECT books.author_name, authors.author_name
FROM books, authors;

How many rows do you get as a result?

Attached file(s):
Attachments
WEEK2_ACCESS2000.mdb  View File
Solution
What is this?
By OTA - Overall OTA Rating
Ramesh Palipi, MSc (IP) - 4.7/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
  • Plain text response
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Query in Access 2000 - You can use the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached to Lecture 1 if you want to play around with this query before answering: OK, I'm writing a query in Access 2000: ...
  • Query - Using the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here Why wont this query run? SELECT authors.author_name FROM authors WHERE authors.author_name Like *twain*;
  • Why wont this query run? - OK, why wont this query run (using the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here)? SELECT author_name FROM author WHERE author_name like "Twain, Mark";
  • Author and tittles - Using the week 2 lecture/homework database, show the author and titles of books that have never sold. Here is the SQL for my question, but what are the author and titles of the books that did not s ...
  • Running a Query - Why wont this query run? SELECT authors.author_name FROM authors WHERE authors.author_name Like *twain*;
Browse