Question: I don't understand what I'm doing wrong with my SQL Query. It's running on Microsoft Access 2016 and the table is under the name EMPLOYEE.
I don't understand what I'm doing wrong with my SQL Query. It's running on Microsoft Access 2016 and the table is under the name EMPLOYEE. Every time I enter this code in it will show the Column headers for FirstName, LastName, and Cellphone but it seems to reject every attempt I make to use an AND or LIKE statement.
| FirstName | LastName | ExperienceLevel | CareerPath | Department |
|---|---|---|---|---|
| Bill | Johnson | Master | Plumber | Maintenance |
| Jerry | Smith | Master | Accounting | Finance |
| Phil | Klein | Rookie | Night Guard | Security |
| John | Billson | Rookie | Accounting | Finance |
SELECT FirstName, LastName, CareerPath FROM EMPLOYEE WHERE FirstName LIKE ('J%') AND ExperienceLevel = 'Master'
;
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
