Seiji Sogabe
sogab****@nttco*****
2006年 1月 31日 (火) 13:52:36 JST
曽我部です。
Kobayashi wrote:
> from " . TABLE_SPECIALS . " s, " .
> TABLE_MANUFACTURERS . " m, " .
> TABLE_PRODUCTS . " p, " .
> TABLE_PRODUCTS_DESCRIPTION . " pd, " .
> TABLE_PRODUCTS_TO_CATEGORIES . " p2c
> where p.products_id = s.products_id
> and m.manufacturers_id = p.manufacturers_id
> (snip)
を、
from " .
TABLE_MANUFACTURERS . " m, " .
TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_DESCRIPTION . " pd, " .
TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " .
TABLE_SPECIALS . " s on p.products_id = s.products_id
where m.manufacturers_id = p.manufacturers_id
(snip)
に変更したらどうでしょうか。
# 確かめたわけではないのですが。