[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:12174

From: "¥¹¡Ý¥Ñ¡¼¥¢¥Õ¥£¥ê¥¨¥¤¥È" <"¥¹¡Ý¥Ñ¡¼¥¢¥Õ¥£¥ê¥¨¥¤¥È" <info@xxxxxxxxxx>>
Date: Sat, 24 Sep 2005 15:26:33 +0900
Subject: [mysql 12174] Re: £Ó£Ñ£Ìʸ¤Ë¤Ä¤¤¤Æ

¼«Í³ÀÊÆõÞÍÍ¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£

>SELECT
> goodstb.id, goodstb.name, goodstb.exp,
> goodstb.comment, goodstb.adtext,
> goodstb.price2, goodstb.price3,
> goodstb.note1, afftb.affst
> FROM goodstb, afftb
> LEFT JOIN afftb ON goodstb.id=afftb.goodsid

> WHERE goodstb.note1=1 And afftb.affst
> Is Null Or afftb.affst=1 And afftb.affid=11113

>¤³¤ì¤ÇÆ°¤­¤Þ¤»¤ó¤Ç¤·¤¿¤Ç¤·¤ç¤¦¤«¡©

Áᮡ¢¤¿¤á¤·¤Ë¥¢¥¯¥»¥¹¤Ç¼Â¹Ô¤·¤¿¤È¤³¤í¡¢¡Ö£Ê£Ï£É£ÎÁàºî¤Î¹½Ê¸¥¨¥é¡¼¤Ç¤¹¡£¡×¤È
¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡£
¥¢¥¯¥»¥¹¤Ç»î¤·¤¿¤«¤é¥À¥á¤Ê¤ó¤Ç¤·¤ç¤¦¤«¡©
£Í£ù£Ó£ñ£ì¤Ç¤Ê¤é¤Ç¤­¤ë¤Î¤Ç¤·¤ç¤¦¤«¡©
¼ÁÌä¤Ð¤«¤ê¤Ç¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¡£



[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

     12172 2005-09-24 07:13 ["¥¹¡Ý¥Ñ¡¼¥¢¥Õ¥£¥ê¥¨¥] £Ó£Ñ£Ìʸ¤Ë¤Ä¤¤¤Æ                        
     12173 2005-09-24 14:57 ¨±[¼«Í³ÀÊÆÃµÞ <kaisoku0]                                       
->   12174 2005-09-24 15:26 ¡¡¨±["¥¹¡Ý¥Ñ¡¼¥¢¥Õ¥£¥ê¥¨¥]