Hi,
Habe zwei Tabellen. Hier die notwendigen Spalten:
<PRE>
products.products_model
products.products_id
</PRE>
<PRE>
products_description.products_name
products_description.products_id
</PRE>
Nun möchte ich anhand der products_model den Wert in products_name editieren.
Habe bisher folgendes probiert:
update products,products_description set products_description.products_description = 'irgendwas' where products_description.products_id = products.products_id and products.products_model = '123';
und
update products_description set products_description.products_description = 'irgendwas' from products_description inner join products on products_description.products_id = products.products_id where products.products_model = '123';
und
update products_description left join products on products_description.products_id = products.products_id set products_description.products_description = 'irgendwas' where products.products_model = '123';
Leider hat es nie geklappt. Hat jemand vielleicht eine Idee woran es liegen könnte?
dermold
Habe zwei Tabellen. Hier die notwendigen Spalten:
<PRE>
products.products_model
products.products_id
</PRE>
<PRE>
products_description.products_name
products_description.products_id
</PRE>
Nun möchte ich anhand der products_model den Wert in products_name editieren.
Habe bisher folgendes probiert:
update products,products_description set products_description.products_description = 'irgendwas' where products_description.products_id = products.products_id and products.products_model = '123';
und
update products_description set products_description.products_description = 'irgendwas' from products_description inner join products on products_description.products_id = products.products_id where products.products_model = '123';
und
update products_description left join products on products_description.products_id = products.products_id set products_description.products_description = 'irgendwas' where products.products_model = '123';
Leider hat es nie geklappt. Hat jemand vielleicht eine Idee woran es liegen könnte?
dermold
Comment