摘要:
SELECT*FROMALEFTJOINBONA.ID=B.IDWHEREB.OTHERKEY=XXXX与SELECT*FROMALEFTJOINBONA.ID=B.IDANDB.OTHERKEY=XXXX是不一样的后者相当于SELECT*FROMALEFTJOINBONA.ID=B.IDWHEREB.OTHERKEY=XXXXORB.OTHERKEYISNULL尽量使用Join而不是Where来... 阅读全文
posted @ 2008-06-16 11:20 AmyQiu 阅读(714) 评论(0) 推荐(0) 编辑