现在要查找所有具有相同的title和address的人
代码如下:select star1.name,star2.name,star1.title,star1.address
from movestar as star1,movestar as star2
where star1.title = star2.title
and star1.address = star2.address
and star1.name
这是一张物料库存的表，有两个库存，甲供物料，乙供物料。
SELECT *,(IFNULL(a_number,0) + IFNULL(b_number,0)) AS stock FROM `materiel_storage`;//注意IFNULL判空
表数据如下：
问：比如这张表我要找出同时满足relevance_id_为00000000000000000001002100040000和00000000000000000001002100030000的abstract_id_应该怎么做？
select abstract_id_,count(abstract_id_) as total_ from note_abstract_rel...
