Biology Forums - Study Force

Science-Related Homework Help Computer Studies Topic started by: lstar1993 on Feb 13, 2019


Title: The following database will be used in this question:GENERAL SALES ...
Post by: lstar1993 on Feb 13, 2019
The following database will be used in this question:

GENERAL SALES DATABASE:

SALESREP
SalesRepNoRepNameHireDate
654Jones01/02/2005
734Smith02/03/2007
345Chen01/25/2018
434Johnson11/23/2004

CUSTOMER
CustNoCustNameBalanceSalesRepNo
9870Winston500345
8590Gonzales350434
7840Harris800654
4870Miles100345

What is an SQL view, and what is it used for? Include an example based on the CUSTOMER table of the General Sales Database.

Title: The following database will be used in this question:GENERAL SALES ...
Post by: Jlynn on Feb 13, 2019
Content hidden


Powered by SMF | SMF © 2015, Simple Machines