If program_id is foreign key in vpt_asset table, then "join" is not necessary here. 
As I understand this query - you want to check which sections exist in vpt_asset table - right?

So this query is enough I think:
```sql
select distinct section from vpt_asset where program_id = 1 and section IN (X) 
```