MySQL查询: searching based on all values in column rather than one value in column

Question

select address
from properties.tblpropertyassetclass_property_mapping  a
INNER JOIN properties.tblproperty b ON a.propertyid = b.propertyid
where propertyassetclassid =2;

这是我目前的疑问。我们可以关注查询的这个特定部分和propertyassetclassid = 2。我想对 propertyassetclassid 中​​的所有值执行此查询[此列中有 25 个随机值]。而不是像这样对每个值进行 AND 运算

   and propertyassetclassid = 4
   and propertyassetclassid = 5
   and propertyassetclassid = 6

我觉得应该有一种更简单的方法来完成我想要完成的任务。

Answer 1

据我所知，您可能想要这样

select address
    from properties.tblpropertyassetclass_property_mapping  a
    INNER JOIN properties.tblproperty b ON a.propertyid = b.propertyid
    where propertyassetclassid is not null