Is it possible to use AND with three tables and using left join/inner join
<p>I am in need  of a very strange problem. I hope you brilliant guys will enjoy this problem (or may be it's an easy task for you :) ). </p>

<p>Here is the query I am using to return values from three tables </p>

<pre><code>   select  listing.*
   , sum(review.rNumber) as nor
   , count(review.rNumber) as total
   , users.username from listing  
   where
   left join review on listing.lid=review.lID
   inner join users on users.uid=listing.cuid
   group by listing.lid
</code></pre>

<p>Now in this query I want to use an additional filter. It is returning all the values from <code>listing table</code> but I want to return all values using <code>WHERE cat='Hair' or something</code></p>

<p>I don't have any idea how to insert where clues in this query.. Please let me know if it doable.
Thanks</p>