SQL Filter Orders by Customers Role : <p>I have two tables and i want display in my output list only orders who have customer role 0. <br>this is my db :</p>

<h3>table1</h3>

<p>Table name : <strong>customers</strong> <br><br>
<strong>id | role | name  <br><br></strong>
1 | 0 | david<br> 
2 | 0 | Opera<br>
3 | 1 | Jacob<br>
<br><br></p>

<h3>table2</h3>

<p>Table name : <strong>orders</strong> <br><br>
<strong>id | customerid | title | price  <br><br></strong>
1 | 1 | hello world | 100 <br> 
2 | 2 | hello world | 100<br>
3 | 3 | hello world | 100<br></p>
