I am using Postgres, one of the latest versions.

I have the following code:

cluster_groups as ( select uc_id, uc_name_imported from team where uc_id in (876,877,878,879,880)) 

The problem is that even though I have specified the list of uc_id in the where clause, I want to only select a value from it IF it exists in the uc_id column in the team table.