How to modify query to only use base tables

Question

How to modify query to only use base tables

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

matthew.livingston SSC Rookie Points: 33 More actions · Answer 1

Not sure if it is okay to post this here, but if this is correct, it will help everyone understand better. OP could help verify.

http://mica.edu.vn/perso/kiendt/doc/EE4253-EE6133/Database%20Design,%20Application%20Development,%20and%20Administration.pdf

pages 365-367

drew.allen SSC Guru Points: 77014 More actions · Answer 2

matthew.livingston (12/20/2016)
Not sure if it is okay to post this here, but if this is correct, it will help everyone understand better. OP could help verify.
http://mica.edu.vn/perso/kiendt/doc/EE4253-EE6133/Database%20Design,%20Application%20Development,%20and%20Administration.pdf
pages 365-367

Yes, it looks like this is the issue.

Database Design, Application Development, and Administration
2. Define a view containing the details of orders placed in January 2007. Include all OrderTbl
columns, OrdLine.Qty, and the product name in the view.
5. Using the view defined in problem 2, write a query to list the rows containing the words Ink Jet
in the product name. Include all view columns in the result.
8. For the query in problem 5, modify the query so that it uses base tables only.

So problem 5 says to use a view that was created in problem 2, and problem 8 says to not use any view.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA