Unknown column 'p.prod_id' in 'on clause' : SELECT img, model, desc_long, desc_short, feat1, feat2, feat3, feat4, feat5, feat6, buy_url, DATE_FORMAT(p.added,'%Y/%m/%d'), package_l, package_w, package_h, package_lbs, amps, volts, circuits, safety, enclosure FROM products p, products_home_acc_specs ps LEFT OUTER JOIN products__offline po ON po.prod_id = p.prod_id WHERE p.prod_id = ps.prod_id AND model = '165-0259'