18. Learn Microsoft Access 2016: How To Use The EXISTS Operator In SQL Queries

[@kentdutrieux8886]

Nice to see the content for us armatures is coming back, thanks Steve

[@ProgrammingMadeEZ]

More to come!

[@battybatty9295]

Thank you 🌹

[@ProgrammingMadeEZ]

You’re welcome 😊

[@jan5310]

Tip: zoom a bit more or use larger font for your query text

[@moshelilintal5547]

Thanks for the great explanation. Why is this easier or better than a simple join query -
SELECT People.ID, FirstName, LastName
FROM People INNER JOIN PeopleTypes ON People.PersonType=PeopleTypes.ID
WHERE typeName NOT LIKE “V*” AND People.Active=Yes