sql server - How to not select rows that does not exists in other table

Question

I want to not select rows where record does not exists in other table

I expect to not select 3 rows where it does not exists on LOCATION table but exist in CYCLE_COUNT_REQUEST

code below

Answer 1

use NOT EXISTS

select *
from CYCLE_COUNT_REQUEST
where not exists (select 1 
                  from LOCATION  )

Or NOT IN:

 select *
    from CYCLE_COUNT_REQUEST
    where NOT IN(select 1 
                      from LOCATION  )