SQL how A table screening according to the two tables the same ID associated B table?



For example:

A table: id
Select * from dweller where buy='no' and (type='1' or type='2' or type='3')


Table B: id