title: mysql workbench connect with multiple database
body: <p>I have two different instances on my workbench localhost and remote server instance shopify_data, (default schema sales_report). Now I want to fetch the data from table zipcode in localhost and other fields that are in another table shopify_orders in remote server shopify_data within sales_report.</p>
  
  <p>The query looks like :</p>
  
  <pre><code>SELECT Name, billing_zip, Billing_Name, Billing_Address1,Billing_Address2, Lineitem_name, Created_at
    FROM sales_report.shopify_orders 
   WHERE Created_at between '2017-08-31' and '2017-09-21' and Billing_Zip in (select zip_code from zipcode);
  </code></pre>
  
  <p>It gives error:</p>
  
  <blockquote>
    <p>sales_report.shopify_orders does not exists.</p>
  </blockquote>
  
  <p>How can I connect my local host instance with shopify_data instance and get data within the same query.</p>
  
  <p>Thanks.</p>
  
  <p>Deepak</p>
  
  <p>PS: I don't want to import the shopify_orders into local host as the value keeps dynamically changing with each order and I don't want to repeat importing </p>