查询b表中bid不为3的数据在a表中是否存在: select a.a1,b.b2 from a inner join b on a.id=b.id where b.bid!=3 and a.is_delete=0