Considerably much like one other query I had however for a category mission we’re utilizing this question:
SELECT E1.EmployeeID, E1.FirstName, E1.LastName FROM EMPLOYEE E1 WHERE EXISTS (SELECT E2.LastName FROM CUSTOMER C1 WHERE E1.LastName = C1.LastName AND E1.FirstName = C1.FirstName);
which works in MySQL and returns four rows. Nevertheless, it does not return any leads to Oracle regardless of each databases having the identical information. Oracle does not give an error message it simply says “No gadgets to show.”
Right here is the information from our Buyer desk on each platforms: https://gyazo.com/8ac99de7f1144f238e7ef530bc71ac20
And right here is the information from the worker desk: https://gyazo.com/f47427190640227e85a7f06dc7a98373
So far as I can inform, the information is similar in each databases and may return the 4 rows that seem in each the Buyer and Worker tables. I’d actually admire if somebody may level out why they’d have completely different outcomes.