test1(a,b)、test2(a,b)
一、inner join:返回关联字段相等的记录
(一)1对1
test1: test2:
select * from test1 a inner join test2 b on a.a=b.a
(二)1对多
test1: test2:
select * from test1 a inner join test2
test1(a,b)、test2(a,b)
test1: test2:
select * from test1 a inner join test2 b on a.a=b.a
test1: test2:
select * from test1 a inner join test2