Question: How do I write this sql query to function on mysql, since 'intersect select' is not valid on mysql: SELECT C.CUST_CODE, C.CUST_FNAME, C.CUST_LNAME FROM LGCUSTOMER

How do I write this sql query to function on mysql, since 'intersect select' is not valid on mysql:

SELECT C.CUST_CODE, C.CUST_FNAME, C.CUST_LNAME FROM LGCUSTOMER C JOIN LGINVOICE I ON C.CUST_CODE=I.CUST.CODE WHERE I.EMPLOYEE_ID=83649 INTERSECT SELECT C.CUST_FNAME, C.CUST_LNAME FROM LGCUSTOMER C JOIN LGINVOICE I ON C.CUST_CODE=I.CUST_CODE WHERE EMPLOYEE ID =38677

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Modify this JAVA code to meet these requirements: When your application starts, it reads a customer name and password from the command line. It validates them against the database and retains the...

Here is Figure 2.26: Here is Figure 2.30: 4. (20pt) Consider the following grammar for a declaration list: decl_list = decl_list decl ; | decl ; decl + id : type type int | real char | array const .....

(20pt) Consider the following grammar for a declaration list: decl_list + decllist decl ; | decl ; decl - id : type type + intreal char | array const .. const of type | record decl_list end Construct...

The textbook's name is Programming Language Pragmatics 4th. 4. (20pt) Consider the following grammar for a declaration list: decl_list + decl_list decl ; | decl ; decl + id : type type + int | real |...

Organization of Programming Languages question The textbook's name is Programming Language Pragmatics 4th. 4. (20pt) Consider the following grammar for a declaration list: decl_list + decl_list decl...

Assessment Details Qualification Code/Title ICT50220 Diploma of Information Technology Assessment Type Assessment -01 (Written Questions) Time allowed Due Date Location AHIC Term / Year Unit of...

Consider the language: P= {w | WE{(,), [,]}*$$, all parentheses in w are properly balanced} . (a) (10pt) Construct a grammar, G1, for P that is LL(1). Build its LL(1) parse table (as in Fig. 2.20) to...

1. BBA-308CHAPTER 13ASSIGNMENT This assignment is on topics related to Chapter 13 of Berk, DeMarzo, and Harford, Fundamentals of Corporate Finance The assignment has a total of 10 questions. You...

4. (20pt) Consider the following grammar for a declaration list: decl_list + decl_list decl ; | decl ; decl + id : type type + int | real | char | array const .. const of type record decl_list end...

Derrick Company establishes a share-appreciation rights program that entitles its new president Dan Scott to receive cash for the difference between the market price of the shares and a...

Rapyd is a payments platform that inserts fintech services into any app and simplifies the complex offering of local payments methods. It has built technology that removes the back-end complexities...

Bryant Inc. just issued $ 1 , 0 0 0 par 3 0 - year bonds. The bonds sold for $ 1 . 1 0 7 . 2 0 and pay interest semiannually, Investors require a rate of 7 . 7 5 % on the bonds. What is the bonds'...

please dont use chat gpt or other AI 7 7 5 .

Assume that the banking system has total reserves of $100 billion. Assume also that required reserves are 10 percent of checking deposits and that banks hold no excess reserves and households hold no...

As shown in Figure 3, the overall labor-force participation rate of men declined between 1970 and 2000. At the same time, the labor-force participation rate of women increased sharply. This overall...

The Bureau of Labor Statistics announced that in February 2008, of all adult Americans, 145,993,000 were employed, 7,381,000 were unemployed, and 79,436,000 were not in the labor force. Use this...