??????????????д???????????дselect * from tbA ??tbB  ??????JOIN???????Low??????????????????JOIN????????????????????????
?????????????
???????????? ?????????????????? (???????)cross join
?????????????????????????????????inner join  on
??????????????????????????????У?????????? ?????????????? full | left | right  outer join  on
????????????
???????????????????????????????????????????????С?
?????????????????????м???where ???????????????
????????
????SELECT title?? pub_name
????FROM titles Cross JOIN publishers
????Where titles.pub_id = publishers.pub_id
????????????????????д????SELECT title?? pub_name  FROM titles ?? publishers Where titles.pub_id = publishers.pub_id
??????й????

??????????
???????????????????е?????е????????????????????е???????????????
????????
????SELECT title?? pub_name
????FROM titles INNER JOIN publishers
????ON titles.pub_id = publishers.pub_id
??????й????

??????????????
????????????????????”??”????????? JOIN ?????????е??????С???????????е??????С?
????????
????SELECT titles.title_id??titles.title??publishers.pub_name
????FROM titles LEFT OUTER JOIN publishers
????ON titles.pub_id = publishers.pub_id
??????????????
????????????????????”??”????????? JOIN ?????????е??????С???????????е??????С?
????????
????SELECT titles.title_id?? titles.title??publishers.pub_name
????FROM titles RIGHT OUTER JOIN publishers
????ON titles.pub_id = publishers.pub_id
??????й????