?????????Join?????????????????и????????????????????????????????????????????????????п??????????????????????????????????漰?????????????Join???????????????????????Join?????????????????????????м?????????????????????????????????????????

??????Join?????????????????????????????????Щ???????????????????????Join???????ζ?????????????????У???????????????Join?????N???????????????У?N-1???ε?Join?????????????1??????2????Join?????Join????????3???????Join??????????

????????Join?????????????????????????????????????

????1??Join???????

????2??Join???????

????????????????????Join??????????????????????????????Join???????μ??????????Join??????????漰????????????????????????????????н?????

??????????????Join??????????????????????????????????????????????????????????м?????????Щ??м??????????????????????Join????????м???????????????

???????Join??????????????????????????????????????????????????Join????????????????????м????????м???????????????Join?????????????????????????????????????????????????Щ??????м????????????????Join??????м????

?????????????????????????????????????????????Щ?????

???????????“??????”?????????????????SQL Server????????????????????????????????????????????????????????????????SQL Server?????????????????????????????Join??????????????????A Join B????B Join A??

????????????????????????????????????????Nest Loops Join??????У?????????????????“????”??????????????“?????”????Hash Join?У???????????????“?????????”??????????“???????”??????????????“????”?????“?????????”??“???????”????????????????

????Join????????????????????????????????A Join B?? Join C????A Join ??B join C??????????????????????棬?????????????????????

????????AdventureWorks????????????????????????????????????????м????

????????????????м???????￡?

?????????????

????1?????????????Join????????(Contact Join Individual)Join Customer??????????м???е?Join???????(Sales.Customer JOIN Sales.Individual) JOIN Person.Contact??

????????????????????????????е?Join??????????????м????????????????????????е??Щ????????????????Join????????????????????????????????????????Join?????????????????????????

????2????????????????????????????????????Join?????????????????Join????????С????????????У??????Join?????????Inner Join???????????????????????????Join??????????????Sales.Customer JOIN Sales.Individual??????????Merge Join?????????????????????????????????????????????????????????????????????????????????????漰????