I'm not a DB guru, but my understanding of joins tells me that you are using more than one table. Are you trying to update *two* tables using one UPDATE statement? On 1 August 2011 09:55, Kibui Maina <mainakibui@gmail.com> wrote:
Hi, I have a *MYSQL Update* Query where I need to use an *inner join* and *where* but its not working, any assistance will be highly appreciated.
UPDATE jos_jreviews_content SET jr_soserviceareapopulation = NULL FROM jos_jreviews_content LEFT JOIN jos_content ON jos_content.asset_id=jos_jreviews_content.contentid WHERE jr_soserviceareapopulation =0
Rgds Kibui Kenneth Maina,* *
* * *Tel:* +254 (0) 721 173 780 *Blog:* Opticom Solutions<http://opticomsolutions.blogspot.com/> *Website*: kit-b.com <http://www.kit-b.com> *Twitter:* @mainakibui<https://twitter.com/#%21/mainakibui>
* * *Tools I Use:* Joomla, PHP, MYSQL, Learning Python, Amazon cloud hosting, WHM, Cpanel, Adobe CS4, Dreamweaver, Cent OS, Linux, Windows, Networking, Hardware, VM Ware.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke