title: mysql join 3 tables and count
body: <p>Please look at this image</p>
  
  <p><a href="https://i.stack.imgur.com/keo83.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/keo83.jpg" alt="alt text"></a>
  </p>
  
  <p>here is 3 tables , and out i want is </p>
  
  <p>uid from table1
  industry from table 3 of same uid
  count of fid from table 2 of same uid</p>
  
  <p>like in the sample example output will be 2 records </p>
  
  <p>Thanks</p>