Update joined table O_O ?

[perrohunter]

hi !

I got this query which gives me a nice joined table

SELECT * FROM pos_coments LEFT JOIN pos_guest USING (gu_id) LEFT JOIN pos_hoteles ON (pos_hoteles.siglas=pos_guest.hotel) LEFT JOIN pos_hotel_gerent USING (hotel) WHERE enddate='0000-00-00' AND ansdate=NOW()

and I'd like to make an update over this table , is that possible ?

[rulian]

I'm not following what you are trying to do,
I see 4 tables here, which table are you trying to update?
if you are thiking of updating accross multiple tables using joins I dont think that is possible. Since we dont retrieve any information on updates other then true or false, error.