1、数据库表结构:
查询:
select * from dbo.A join B on A.T1=B.T3
select * from dbo.A Inner join B on A.T1=B.T3
select * from dbo.A LEFT join B on A.T1=B.T3
select * from dbo.A right join B on A.T1=B.T3
结果:
1、数据库表结构:
查询:
select * from dbo.A join B on A.T1=B.T3
select * from dbo.A Inner join B on A.T1=B.T3
select * from dbo.A LEFT join B on A.T1=B.T3
select * from dbo.A right join B on A.T1=B.T3
结果: