title: SQL join, get data from one table
body: <p>I have a question about joins. How to get all Order of Customer with a specified name.</p>
  
  <p>In my result I want only have all columns from "Orders" table and zero columns from "Customers" table. Here you can see tables: 
  <a href="https://www.w3schools.com/sql/sql_join.asp" rel="nofollow noreferrer">https://www.w3schools.com/sql/sql_join.asp</a></p>
  
  <pre><code>SELECT *
  FROM Orders
  LEFT JOIN Customers
  ON Orders.CustomerID=Customers.CustomerID
  WHERE CustomerName = "Wilman Kala"
  </code></pre>
  
  <p>I tested this here: 
  <a href="https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_join" rel="nofollow noreferrer">https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_join</a> 
  It returns all columns from two tables.</p>
  
  <p>Thanks in advance for a help.</p>