mssql ¹ØÓÚwhereÓï¾äµÄλÖÃ

ÀýÈ磺select a.* from (select id,code from b left join c on b.id=c.id)a where id=1
ÕâÀïµÄwhere ÔÚÖ´ÐеÄʱºò£¬ where »áÓÅ»¯ÊÇ·ñ½øÈ뵽СÀ¨ºÅÀïÃæÖ´ÐÐ?????

---

SQL code:
select id,code from b left join c on b.id=c.id
where id=1

---

ÒýÓÃ

SQL codeselect id,codefrom bleftjoin con b.id=c.idwhere id=1

ÔÎÄãµÄÓï¾äÖÐ idºÍcodeÒªÖ¸¶¨ÊÇÄĸö±íµÄ¡£È磺b.id c.code:
select id,code from b left join c on b.id=c.id where id=1

---

È磺
select b.id,c.code from b left join c on b.id=c.id
where b.id=1

---

SQL code:
select B.id,B.code from b left join c on b.id=c.id AND B.id=1
SQL code:
select B.id,B.code from b left join c on b.id=c.id WHERE B.id=1

---

SQL code:
ÓÖÉæ¼°µ½whereºÍandµÄÎÊÌâ