title: In Mariadb, my select queries on multiple tables return excessive rows
body: <p>I'm very new to Maria db but I haven't found a solution to this problem. I have a database with several tables. Two of the tables are employees and customers. They have no relation to each other.</p>
  
  <pre><code>create table clients (id int, name varchar(50), city varchar (20))
  create table workers (id int, name varchar (50), city varchar(20))
  </code></pre>
  
  <p>I'm trying to write a select query that will return the name of a city, the total number of workers,  and the total number of clients in that city. The clients table has over 2000 entries and the workers table has 60.</p>
  
  <p>The problem is that if I do this:</p>
  
  <pre><code>Select workers.id, clients.id from workers, clients; 
  </code></pre>
  
  <p>I get 120,000 rows (60 * 2000). How do I achieve my goal?</p>
  
  <p>Sorry if the formatting is weird. </p>