????sql???????????? ???????? ???????? ????????????????????????????????????????????????????й???? ??????????????????sql???????У? ??????sql???????????????η?? ????????????????????????ε???????????? ?????? ??????????????Σ?????????3??????ī???????BUG??
???????????????У??????????????????on????where???????????  ???????д???????? ??????????ò???????on???滹??where???棬 ??????????????????? ????????????????????????sql?????????????????  ?????? ???????????????????????????????????????????
????sql?е??????????3??? cross join??inner join????outer join ??  ?? cross join??inner join?У???????????on???滹??where???????????????????????д????????????????????on?????where??????????????on????where????????????outer join?????????????left join??right join??
??????????????????????????????????????????
??????main

??????ext

????????????????????????????????????? main????????????ext???????????????????????1??1?????id??????????????????????????????????????????????????????????????????????main???ext???????????????
????select * from main left JOIN  exton main.id = ext.id  and  address <> '????'
????????????? ?????????????????????SQL?? ????????????????

???????? address <> '????' ?????????????on??????????????????????????е???????????????????????????????????????ext???ж??????????main???е???????б??????????????б?????????????????outer join?????inner join??????????????????????????????????????????????????????????????????????δ??????????Щ??
???????????????????￡????????????????on?????where
????select * from main left JOIN  ext on main.id = ext.id  where address <> '????'
???????????????????????

??????????????????????outer join??????????????????????????????outer join ????й?????4??
????1?????????????н???????(???????)
????2?????on????
????3?????????
????4?????where????
?????????治???where??????sql???????е????????????????
?????????????????????н??????????????￡???????????36??????????????????

??????????????on????????????????????????main.id = ext.id  and address<> '????'????????????????

??????????????????????в?????????????????????????????????????
??????????????????С?outer join???????????????????????????????????з???on????????????????null?????????ε????У????????????????????????????????????????????

????????????????????о??? ???????????

??????????????where????
??????????????sql?У???????where?????????????????????????????
?????????????????????where?????е?sql???????????????????????е?????????????????????

??????????????????????????outer join?е?????????on?к?where?е????????????????????????в???????????дsql?????г????ī??????????