I have a couple of tables I’m joining and only want to return users that a field missing in the joined table.

Users
id
fname
lname

userMeta
id
metaKey
metaValue

I’m trying to find users that don’t have a record in the userMeta table of metaKey = userpro_verified

select * 
from Users 
where id not in (select id from userMeta where m.metaKey = "userpro_verified")

Leave a Reply