Thanks @ Chris Mwirigi.... worked like a charm :) 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. On Mon, Aug 1, 2011 at 10:22 AM, Chris Mwirigi <mwirigic@gmail.com> wrote:
UPDATE jos_jreviews_content
LEFT JOIN jos_content ON jos_content.asset_id=jos_jreviews_content.contentid SET jr_soserviceareapopulation = NULL WHERE jr_soserviceareapopulation =0
On Mon, Aug 1, 2011 at 10:02 AM, Wilson Bandi <bandson67@gmail.com> wrote:
Kibui,
What are you trying to achieve because there are better ways of doing this. In my view you are mixing up stuff and would suggest you do a subquery.
Wilson.
On Mon, Aug 1, 2011 at 9:55 AM, 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
-- Kind Regards,
Wilson B.
_______________________________________________ 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
_______________________________________________ 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