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

>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

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

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