SQL264热题
该问题的创新点是一个表e的两列send_id,receive_id都是一样的要求,来自另一个表u(is_balcklist=0),
这个时候我们需要设置两个另外的表u1,u2
join user as u1 on e.send_id = u1.id
join user as u2 on e.send_id = u2.id
where u1.is_blacklist =0 and u2.blacklist = 0
#笔试#该问题的创新点是一个表e的两列send_id,receive_id都是一样的要求,来自另一个表u(is_balcklist=0),
这个时候我们需要设置两个另外的表u1,u2
join user as u1 on e.send_id = u1.id
join user as u2 on e.send_id = u2.id
where u1.is_blacklist =0 and u2.blacklist = 0
#笔试#相关推荐
招聘动态