found you!

Convoy or ShawShank

past tense.

try contact rather than cotact....

outer apply, so very cool.
derived table with join to primary table...

select i.individual_id
from individual i
outer apply (select n.individual_id
from nag_table n
where n.email_ind = 1 and nag_update = 1
and n.individual_id = i.individual_id
) nn

#sql

hey I made an #SEO Starter Pack if you're new here and looking for SEO people to follow.

pls share so others can find: