-_-! ??? A join B on A.a = B.b and A.a is not NULL
select * from A inner join B on A.a=B.b and A.a is not null
直接 inner join 就行了,如果你不特别设置 null 是不等于 null 的 select * from A inner join B on A.a=B.b
select * from A inner join B on A.a=B.b and A.a is not null
两张表 表A 表B A中有个字段a,B中有个字段b 如果我想在a 不是null时和B表inner join,请问这个怎么写?法1:inner join其实就是join,返回的记录是表A和B同时都有的记录select a, b from A inner join B on A.a=B.b 法2:如果在a不为null时和B表做inner join,也可以使用left join实现,因为left join就是返回A表所有记录,B表的b列如果没有则用null补全。select a, b from A left join B on A.a=B.b
select a.a,b.b from A a inner join B b on a.id=b.aId and a.a is not null
A
join B on A.a = B.b and A.a is not NULL
select * from A inner join B on A.a=B.b
A中有个字段a,B中有个字段b
如果我想在a 不是null时和B表inner join,请问这个怎么写?法1:inner join其实就是join,返回的记录是表A和B同时都有的记录select a, b
from A inner join B
on A.a=B.b
法2:如果在a不为null时和B表做inner join,也可以使用left join实现,因为left join就是返回A表所有记录,B表的b列如果没有则用null补全。select a, b
from A left join B
on A.a=B.b
from A a
inner join
B b
on
a.id=b.aId and a.a is not null