Question
Query: Show the employee first name, last name, and education level for only those employees with an entered education level, so that your results are
Query: Show the employee first name, last name, and education level for only those employees with an entered education level, so that your results are as in the following table. (Hint: only a single table select using employee; JOIN with others; do not use WHERE.)
employee table has following column names: table name: employee :: Column names: ID, firstName,lastName, jobTitle, salary, notes PRIMARY KEY is ID Table Name: Education :: column names: ID, edname PRIMARY KEY Is ID
Table Name: employee_education :: column name: employeeID, educationID
compound primary key from employeeID and educationID fk_Employee_EmployeeID indicating that employeeID is a foreign key for the ID field in table employee
fk_Education_EducationID indicating that educationID is a foreign key for the ID field in table education
Need help with this MySQL query.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started