title: Simple query for listing elements in mysql
body: <p><strong>I have two tables</strong>::</p>
  <pre><code>mysql&gt; SELECT * FROM MasterListItemtype;
  +----------------------+------------------------+
  | MasterListItemtypeID | MasterListItemtypeName |
  +----------------------+------------------------+
  |                    1 | Starters               |
  |                    2 | Main Course            |
  |                    3 | Side Course            |
  |                    4 | Others                 |
  |                    5 | Desert                 |
  +----------------------+------------------------+
  5 rows in set (0.00 sec)
  
  mysql&gt; SELECT * FROM MasterListMenuItems;
  +------------------+-----------------------+-------+----------------------+
  | MasterListMenuID | MasterListMenuName    | Vegan | MasterListItemtypeID |
  +------------------+-----------------------+-------+----------------------+
  |                1 | Vada                  |     1 |                    1 |
  |                4 | Chinese Chicken Salad |     0 |                    1 |
  |                5 | Dosa Chicken Salad    |     0 |                    1 |
  |                6 | Gobi Manchuri         |     1 |                    2 |
  |                7 | Indian Salad          |     1 |                    3 |
  |                8 | Gobi Chilli Manchuri  |     1 |                    2 |
  |                9 | Chocolate IceCream    |     1 |                    5 |
  |               10 | Vanilla IceCream      |     1 |                    5 |
  +------------------+-----------------------+-------+----------------------+
  8 rows in set (0.00 sec)
  </code></pre>
  <hr />
  <p><strong>note here</strong>::</p>
  <ul>
  <li><p><code>MasterListMenuID</code> is primary key of <code>MasterListMenuItems</code></p>
  </li>
  <li><p><code>MasterListItemtypeID</code> is primary key of <code>MasterListItemtype</code></p>
  </li>
  <li><p><code>MasterListItemtypeID</code> is Foreign key of <code>MasterListMenuItems</code></p>
  <p>.</p>
  </li>
  </ul>
  <hr />
  <p><strong>How to make a Mysql query so that</strong>::</p>
  <p>I need to list the elements in <code>MasterListMenuName</code> of table <code>MasterListMenuItems</code> which are <code>starters</code></p>