PHP博客-zwws's blog-最新评论http://www.phpweblog.net/zwws/CommentsRSS.aspxBlog For PHP Learning...zh-cnWed, 02 Apr 2008 10:08:55 GMTWed, 02 Apr 2008 10:08:55 GMTcnblogsre: 顺序输出 123A, 123B,123C... 实现方式。http://www.phpweblog.net/zwws/archive/2008/04/02/921.html#31242131221312Wed, 02 Apr 2008 10:09:00 GMThttp://www.phpweblog.net/zwws/archive/2008/04/02/921.html#3124

21312 2008-04-02 18:09 发表评论
]]>re: sql的left join 命令详解http://www.phpweblog.net/zwws/archive/2008/03/28/944.html#3074深山狩猎人深山狩猎人Fri, 28 Mar 2008 03:57:00 GMThttp://www.phpweblog.net/zwws/archive/2008/03/28/944.html#3074

深山狩猎人 2008-03-28 11:57 发表评论
]]>re: sql的left join 命令详解[未登录]http://www.phpweblog.net/zwws/archive/2008/03/17/944.html#2987ruderalruderalMon, 17 Mar 2008 10:11:00 GMThttp://www.phpweblog.net/zwws/archive/2008/03/17/944.html#2987on a.aid = b.bid and a.aid = 3
等于
select * from a left join b
on a.aid = b.bid where a.aid = 3 or a.aid is null

ruderal 2008-03-17 18:11 发表评论
]]>re: sql的left join 命令详解http://www.phpweblog.net/zwws/archive/2008/03/11/944.html#2947fishbonefishboneTue, 11 Mar 2008 08:21:00 GMThttp://www.phpweblog.net/zwws/archive/2008/03/11/944.html#2947
select * from a left join b
on a.aid = b.bid and a.aid = 3

select * from a left join b
on a.aid = b.bid where a.aid = 3

能解释一下为什么这两个查询的结果不一致?

email: lucky7_2000@126.com

fishbone 2008-03-11 16:21 发表评论
]]>re: SQL--JOIN之完全用法(版本2)http://www.phpweblog.net/zwws/archive/2008/02/20/946.html#2801hasiyhasiyWed, 20 Feb 2008 08:08:00 GMThttp://www.phpweblog.net/zwws/archive/2008/02/20/946.html#2801

hasiy 2008-02-20 16:08 发表评论
]]>re: sql的left join 命令详解http://www.phpweblog.net/zwws/archive/2007/12/11/944.html#2527fqfqTue, 11 Dec 2007 02:34:00 GMThttp://www.phpweblog.net/zwws/archive/2007/12/11/944.html#2527

fq 2007-12-11 10:34 发表评论
]]>re: sql的left join 命令详解http://www.phpweblog.net/zwws/archive/2007/11/26/944.html#2393mengmengMon, 26 Nov 2007 09:57:00 GMThttp://www.phpweblog.net/zwws/archive/2007/11/26/944.html#2393
Thank you!!!!!!!!!

meng 2007-11-26 17:57 发表评论
]]>re: sql的left join 命令详解http://www.phpweblog.net/zwws/archive/2007/11/08/944.html#2211dfdfThu, 08 Nov 2007 01:14:00 GMThttp://www.phpweblog.net/zwws/archive/2007/11/08/944.html#2211

df 2007-11-08 09:14 发表评论
]]>re: SQL--JOIN之完全用法(版本1)http://www.phpweblog.net/zwws/archive/2007/08/22/945.html#1791林林Wed, 22 Aug 2007 07:40:00 GMThttp://www.phpweblog.net/zwws/archive/2007/08/22/945.html#1791

林 2007-08-22 15:40 发表评论
]]>re: sql的left join 命令详解http://www.phpweblog.net/zwws/archive/2007/08/10/944.html#1700小丫小丫Fri, 10 Aug 2007 03:19:00 GMThttp://www.phpweblog.net/zwws/archive/2007/08/10/944.html#1700

小丫 2007-08-10 11:19 发表评论
]]>