Thanks @ Chris Mwirigi.... worked like a charm :)<div><br></div><div>Rgds,<br clear="all">Kibui Kenneth Maina,<b><br></b><div><br></div><div><b><br></b></div><div><b>Tel:</b> +254 (0) 721 173 780 <b>Blog:</b> <a href="http://opticomsolutions.blogspot.com/" target="_blank">Opticom Solutions</a> <b>Website</b>: <a href="http://www.kit-b.com" target="_blank">kit-b.com</a> <b>Twitter:</b> <a href="https://twitter.com/#%21/mainakibui" target="_blank">@mainakibui</a></div>

<div><br></div><div><img src="http://kit-b.com/templates/shape5_intrigue/images/mainakibui.png"><br></div><div><div><b><br></b></div><div><b>Tools I Use:</b></div><div>Joomla, PHP, MYSQL, Learning Python, Amazon cloud hosting, WHM, Cpanel, Adobe CS4, Dreamweaver, Cent OS, Linux, Windows, Networking, Hardware, VM Ware.</div>

</div><br>
<br><br><div class="gmail_quote">On Mon, Aug 1, 2011 at 10:22 AM, Chris Mwirigi <span dir="ltr">&lt;<a href="mailto:mwirigic@gmail.com">mwirigic@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

UPDATE jos_jreviews_content<div class="im"><br>LEFT JOIN jos_content<br>ON jos_content.asset_id=jos_jreviews_content.contentid<br></div>SET jr_soserviceareapopulation = NULL <br>WHERE jr_soserviceareapopulation =0<div><div>

</div><div class="h5"><br><br><br><br><div class="gmail_quote">
On Mon, Aug 1, 2011 at 10:02 AM, Wilson Bandi <span dir="ltr">&lt;<a href="mailto:bandson67@gmail.com" target="_blank">bandson67@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">


Kibui, <br><br>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.<br><br><br>Wilson.<br><br><div class="gmail_quote"><div><div>


</div><div>On Mon, Aug 1, 2011 at 9:55 AM, Kibui Maina <span dir="ltr">&lt;<a href="mailto:mainakibui@gmail.com" target="_blank">mainakibui@gmail.com</a>&gt;</span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex"><div><div></div><div><div>Hi, I have a <b>MYSQL Update</b> Query where I need to use an <b>inner join</b> and <b>where</b> but its not working, any assistance will be highly appreciated.</div>



<div><br></div><div>UPDATE jos_jreviews_content</div>

<div>SET jr_soserviceareapopulation = NULL </div><div>FROM jos_jreviews_content</div><div>LEFT JOIN jos_content</div><div>ON jos_content.asset_id=jos_jreviews_content.contentid</div><div>WHERE jr_soserviceareapopulation =0</div>





<div><br></div><div><br></div><div>Rgds</div>Kibui Kenneth Maina,<b><br></b><div><br></div><div><b><br></b></div><div><b>Tel:</b> <a href="tel:%2B254%20%280%29%20721%20173%20780" value="+254721173780" target="_blank">+254 (0) 721 173 780</a> <b>Blog:</b> <a href="http://opticomsolutions.blogspot.com/" target="_blank">Opticom Solutions</a> <b>Website</b>: <a href="http://www.kit-b.com" target="_blank">kit-b.com</a> <b>Twitter:</b> <a href="https://twitter.com/#%21/mainakibui" target="_blank">@mainakibui</a></div>





<div><br></div><div><img><br></div><div><div><b><br></b></div><div><b>Tools I Use:</b></div><div>Joomla, PHP, MYSQL, Learning Python, Amazon cloud hosting, WHM, Cpanel, Adobe CS4, Dreamweaver, Cent OS, Linux, Windows, Networking, Hardware, VM Ware.</div>





</div><br>
<br></div></div><div>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></div></blockquote></div><font color="#888888"><br><br clear="all"><br>-- <br>Kind Regards,<br><br>Wilson B.<br><br><br>
</font><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div>