连接

--内连接
--语法：    from 表1 join 表2 on 表1.字段=表2.字段
select * from sn_info join group_sn_info  on sn_info .sn =group_sn_info.fan_sn 

将两张表合成一张表找2个相同的字段的条件.

--内连接

select 
  t1.sn
 ,t2.fan_sn
 ,t2.assy_sn 
 ,t1.test_result 
from 
 sn_info as t1
  inner  join      --( inner可以省略)
  group_sn_info as t2
 on 
 t1.sn =t2 .fan_sn

where t1.sn ='20500-0001-A02-00000073'  (where 也可不写)

---使用条件筛选后的数据，但要一定要对称,如果t1表中有一条件与t2表不能完全对应上，好像就不行

--外连接

-左表查寻

select 
 t1.position_id 
 ,t1.sn
 ,t2.fan_sn
 ,t2.assy_sn 
 ,t1.attribute1 
 ,t1.attribute2 
 ,t1.attribute3 
 ,t1.attribute4 
 ,t1.test_result  as 'Result'
from 
 sn_info as t1
  left join 
  group_sn_info as t2
 on 
 t1.sn =t2 .pcba_sn  

where t1.sn ='20500-0001-A02-00000073'  (where 也可不写)

--右表查寻

select 
 t1.position_id 
 ,t1.sn
 ,t2.fan_sn
 ,t2.assy_sn 
 ,t1.attribute1 
 ,t1.attribute2 
 ,t1.attribute3 
 ,t1.attribute4 
 ,t1.test_result  as 'Result'
from 
 sn_info as t1
 right join 
  group_sn_info as t2
 on 
 t1.sn =t2 .pcba_sn  

where t1.sn ='20500-0001-A02-00000073'  (where 也可不写)

多张表连接

select 
*
from 
 sn_info as t1
 inner join 
  group_sn_info as t2
 on 
 t1.sn =t2 .pcba_sn  

  join 
  PoSeting  as t3
  on t1.Po =t3.Po ----3张表连接

where t1.sn ='20500-0001-A02-00000073'  (where 也可不写)