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 Website: kit-b.com Twitter: @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