title: Mysql: query not giving accurate result with IN clause and inner query
body: <p>I'm trying to get zip codes from zip_id's which are internally stored in companies service table below screens will give you clear idea </p>
  
  <p><strong>I have wrote this query</strong>
   <img src="https://i.stack.imgur.com/tkjM7.png" alt="enter image description here"></p>
  
  <p><strong>companies service table</strong>
  <img src="https://i.stack.imgur.com/WczVG.png" alt="enter image description here"></p>
  
  <p>Please suggest me your valuable views . Thanks in advance.</p>