title: Inner join table in case condition MySql
body: <p>I have a scenario in which I want to inner join a table when it meets a condition. I want something like </p>
  
  <pre><code>SELECT * FROM table_1 
  CASE 
      WHEN some_condition THEN INNER JOIN table_2 ON some_other_condition
  END
  </code></pre>
  
  <p>I have gone through many references and previous StackOverflow answers. But, those don't meet my requirement.</p>
  
  <p><strong>EDIT :</strong></p>
  
  <pre><code>Table 1
  id  |  name  |  price
  1   |  aaa   |  111
  2   |  bbb   |  222
  ____________________
  
  Table 2
  id  |  discountedPrice  |  orgId
  1  |   100          |        org1
  2  |   200          |        org2
  </code></pre>
  
  <p>Added tables. For some organizations, I want to show the only price. But, some users have a price discount. So, want to show the discount to few users. So, I want to inner join conditionally.</p>