Query mit LEFT JOIN umschreiben - wie?

[wire003]

Hi,

habe folgendes Query:

    $product_info_query = tep_db_query("select p.products_id, pd.products_name,
pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url,
p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available,
 p.manufacturers_id, pi.products_image1, pi.products_image2, pi.products_image3, 
pi.products_image4, pi.products_image5,    pi.products_image6, pi.products_image7, pi.products_image8, pi.products_image9
     FROM ".TABLE_PRODUCTS." 
p,".TABLE_PRODUCTS_DESCRIPTION." pd,".TABLE_PRODUCTS_IMAGES." pi 
WHERE p.products_status = '1' AND p.products_id = '".(int)$HTTP_GET_VARS['products_id']."' 
AND pd.products_id = p.products_id 
AND pi.products_id = '30' AND pd.language_id = '" . (int)$languages_id . "'"); 

Jetzt muss ich die letzten Bedingungen (vor allem AND pi.products_id = '30') mit LEFT JOIN umschreiben, denn sonst funktioniert das Query nicht wenn die pi.products_id "30" nicht existiert. (soll es aber!)

Wie mache ich das ? Habe schon viel versucht, aber ich finde auch kein gutes Manual dazu :/

Es wäre sehr nett wenn mir einer helfen könnte.

[TBT]

Zeilenumbruch!!!

[mrhappiness]

1. http://php-resource.de/forum/showthr...threadid=50454

2. http://php-resource.de/forum/showthr...threadid=28292

[wire003]

Hm, ok danke schon mal!

Habe das jetzt so umgeschrieben, aber es kommt ein Fehler...

        $product_info_query = tep_db_query("select p.products_id, pd.products_name,
pd.products_description, p.products_model, p.products_quantity, p.products_image,
pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available,
p.manufacturers_id, pi.products_image1, pi.products_image2, pi.products_image3,
 pi.products_image4, pi.products_image5,    pi.products_image6, pi.products_image7, pi.products_image8, pi.products_image9
     FROM ".TABLE_PRODUCTS."
 p,".TABLE_PRODUCTS_DESCRIPTION." pd, INNER JOIN ".TABLE_PRODUCTS_IMAGES." pi
 ON pi.products_id = p.products_id WHERE p.products_status = '1'
 AND p.products_id = '".(int)$HTTP_GET_VARS['products_id']."' AND pd.products_id = p.products_id  
AND pd.language_id = '" . (int)$languages_id . "'"); 

[wahsaga]

Original geschrieben von wire003
Habe das jetzt so umgeschrieben, aber es kommt ein Fehler...

Interessant.

[wire003]

sorry, hier ist die fehlermeldung.

1064 - You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near
 'INNER JOIN products_images pi ON pi.products_id = p.products_id WHERE p.products' at line 2

select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image,
pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, 
p.manufacturers_id, pi.products_image1, pi.products_image2, pi.products_image3, pi.products_image4,
 pi.products_image5,
 pi.products_image6, pi.products_image7, pi.products_image8, pi.products_image9 FROM products p,products_description pd,
 INNER JOIN products_images pi ON pi.products_id = p.products_id WHERE p.products_status = '1'
 AND p.products_id = '3' AND pd.products_id = p.products_id AND pd.language_id = '2'

[TEP STOP] 

[wire003]

Kann ich noch irgendwas ergänzen ?

[TBT]

vor dem INNER steht ein , zu viel

[closure]

Hi

du hast ein komma zu viel. Lösch mal das komma das direct vor

INNER JOIN products_images .....

steht.


greets

EDIT:

---

too late

---

[wire003]

Herzlichen Dank