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,
Tools I Use:
Joomla, PHP, MYSQL, Learning Python, Amazon cloud hosting, WHM, Cpanel, Adobe CS4, Dreamweaver, Cent OS, Linux, Windows, Networking, Hardware, VM Ware.
