Menu

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