title: How to display data from multiple tables in SQL
body: <p>I'm relatively new to SQL. I'm trying to figure out how to satisfy this condition:    Display <code>customer_id, customer_last_name, order_id,order_item_id, product_name</code> for any customer living in Virginia.</p>
  
  <p>So far, I have this, but I'm not sure how to display the values together. Any help will be appreciated. </p>
  
  <pre><code>SELECT customer_id, cust_first_name
  FROM demo_customers
  WHERE cust_state= 'VA'
  
  SELECT order_id
  FROM demo_orders
  WHERE customer_id= '1'
  </code></pre>