title: How to use between in MySQL ansi query?
body: <p>I need to query something using INNER JOIN how can i use <code>WHERE user_id between 2000 and 3000</code> inside ANSI query</p>
  
  <p>e.g. </p>
  
  <pre><code>SELECT table1.name, table2.wage, table2.bonus table3.shift, table4.vacation
  FROM table1
  INNER JOIN table2 ON table1.userid = table2.userid
  INNER JOIN table3 ON table2.userid = table3.userid
  INNER JOIN table4 ON table4.userid = table4.userid 
  LEFT JOIN table5 ON table1.name = table5.position
  </code></pre>
  
  <p>also i need to limit table2.wage bwtween 2000 to 4000 how can i represent it</p>