表连接提示:
1、select aa.*,a.*
from dbo.a inner hash/loop/merge join dbo.aa on a.aa=aa.a1;
2、select aa.*,a.*
from dbo.a inner remote join dbo.aa on a.aa=aa.a1; --指定联接操作在右表处执行。只可用于 INNER JOIN 操作。
查询提示:
1、select aa.*,a.*
from dbo.a inner join dbo.aa on a.aa=aa.a1
option(loop/merge/hash join) ;
表提示:
1、select s1.*,s2.*
from dbo.a s1 with (nolock) inner join dbo.aa s2 with (nolock) on s1.aa=s2.a1
官方文档地址:https://msdn.microsoft.com/zh-cn/library/ms187373(v=sql.105).aspx