This link contains SQL text file that relates to this question. Please advise as

Question

This link contains SQL text file that relates to this question. Please advise as to whether or not it works:?

https://www.dropbox.com/sh/77znbhonpjo8k40/AABDVaf2ozfhDFFaFmvQNWSta?dl=0

Thanks.

-FIGURE P8.24 CUSTOMERS WITH INVOICES FILLED BY EMPLOYEES 83649 AND 83677 Cust Code Cust FNarne Cust LName 684 WENDI BEAN BURRIS CAUDILL DILLARD ERICKSON HOWE LYON 340 MARCIA 211 GERALD 292 VALARIE 293 CLAIR 16 TATIANA 996 EZRA 98 VALENTIN MARINO 21 PETER SMALL 1157 LUCIO 617 CESAR 457 SHAUNA STALEY TALLEY WERNER WHALE 131 SAL

Explanation / Answer

Select C.Cust_Code, C.Cust_Fname, C.Cust_Lname

From LGCUSTOMER C INNER JOIN LGINVOICE I1

ON C.Cust_Code = I1.Cust_Code

INNER JOIN LGINVOICE I2

ON C.Cust_Code = I2.Cust_Code

Where I1.Employee_ID = 83649

AND I2.Employee_ID = 83677

GROUP BY C.Cust_Code, C.Cust_Fname, C.Cust_Lname

ORDER BY C.Cust_Lname, C.Cust_Fname;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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