these are my tables.. //CUSTOMER CREATE TABLE CUSTOMER (Cust_Num VARCHAR (3), Cu

Question

these are my tables..


//CUSTOMER

CREATE TABLE CUSTOMER
(Cust_Num VARCHAR (3),
Cust_Fname VARCHAR (15),
Cust_Lname VARCHAR (15),
Cust_address VARCHAR (30),
Cust_PhoneNumber CHAR (10),
Cust_SSN CHAR (9),
Cust_DOB DATE,
CONSTRAINT pk_CUSTOMER PRIMARY KEY (Cust_Num));

//INVOICE

CREATE TABLE INVOICE
(Inv_Number INT,
Inv_Date DATE,
Inv_Type VARCHAR (15),
Inv_Phonenumber CHAR (10),
Inv_Fax CHAR (10),
Inv_Address VARCHAR (30),
Inv_Balance VARCHAR (4),
CONSTRAINT pk_INVOICE PRIMARY KEY (Inv_Number));

//SALES REP

CREATE TABLE SALESREP
(SalesRep_Num CHAR (4),
SalesRep_Fname VARCHAR (15),
SalesRep_Lname VARCHAR (15,
SalesRed_Deptcode CHAR (6),
SalesRep_Initials VARCHAR (2),
SalesRep_ExtenionNum CHAR (4),
CONSTRAINT pk_SALESREP PRIMARY KEY (SalesRep_Num));

//PRODUCT

CREATE TABLE PRODUCT
(Prod_name VAR CHAR (30),
Prod_Vend_Id CHAR (5),
Product_Details VARCHAR (30),
Prod_Cost VARCHAR (5),
CONSTRAINT pk_PRODUCT PRIMARY KEY (Prod_Vend_Id));

//VENDOR
CREATE TABLE VENDOR
(Vend_Number CHAR (5),
Vend_name VARCHAR (15),
Vend_Adress VARCHAR (30),
Vend_Phonenumber CHAR (10),
Vend_Fax CHAR (10),
Vend_Email VARCHAR (30),
CONSTRAINT pk_VENDOR Vend_Number));

the query i need is as follows:


Give the invoice number, product names and their vendors,
And the name of the sales rep for customer number = 101.

Explanation / Answer

Query: Give the invoice number, product names and their vendors, And the name of the sales rep for customer number = 101. SQL Statement: SELECT Inv_Number, Prod_Name, Vend_name, SalesRep_FName, SalesRep_LName As SalesRep_Name FROM CUSTOMER, INVOICE, SALES REP, PRODUCT, VENDOR WHERE Cust_Num = 101

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.