I'm trying to get results from below query. It returns 0 rows but I know there are some records.
FROM offense a with (nolock)
inner join empmast b on a.user_key = b.perno
where KEY1 in ('ECSO19OFF006971','ECSO19OFF005406','ECSO16OFF011326','ECSO16OFF011299','ECSO16OFF002158','ECSO19OFF006999','ECSO19OFF006971','ECSO18OFF010285',
AND KEY1 IN (select UNIQUEKEY
from OFFENSE with (nolock))
order by event_date desc
Each of the long 'ECSOOFF' numbers has a UNIQUEKEY field in another table.
Thanks for your help so much. I appreciate it.