Don T Understand M Wrong Sql Query S Running Microsoft Access 2016 Table Name Employee Eve Q43833957
I don’t understand what I’m doing wrong with my SQL Query. It’srunning on Microsoft Access 2016 and the table is under the nameEMPLOYEE. Every time I enter this code in it will show the Columnheaders for FirstName, LastName, and Cellphone but it seems toreject every attempt I make to use an AND or LIKE statement.
FirstNameLastNameExperienceLevelCareerPathDepartmentBillJohnsonMasterPlumberMaintenanceJerrySmithMasterAccountingFinancePhilKleinRookieNight GuardSecurityJohnBillsonRookieAccountingFinance
SELECT FirstName, LastName, CareerPath
FROM EMPLOYEE
WHERE FirstName LIKE (‘J%’)
AND ExperienceLevel = ‘Master’
;
Expert Answer
Answer to 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 …
OR