title: ERROR 1054 (42S22): Unknown column 'employee' in 'field list' in MySQL
body: <h1>I'm not sure why I'm getting this error message ERROR 1054 (42S22): Unknown column 'employee' in 'field list'.</h1>
  <p><a href="https://i.stack.imgur.com/WJX9i.png" rel="nofollow noreferrer">Employee Table Description</a></p>
  <p><a href="https://i.stack.imgur.com/RJm1R.png" rel="nofollow noreferrer">Employee Table</a></p>
  <p><a href="https://i.stack.imgur.com/vPQ6Q.png" rel="nofollow noreferrer">Work Table Description</a></p>
  <p><a href="https://i.stack.imgur.com/HdcMn.png" rel="nofollow noreferrer">Work Table</a></p>
  <p>This is the datatypes for Employee Table and the values inserted:</p>
  <pre><code>mysql&gt; create table employee (`employee-name` char(30), `street` char(30), 
  `city` char(30));
  mysql&gt; insert into employee values ('John Smith', 'Street A', 'City 1');
  mysql&gt; insert into employee values ('Arya Stark', 'Street B', 'City 2');
  mysql&gt; insert into employee values ('Barry Allen', 'Street C', 'City 3');
  mysql&gt; insert into employee values ('Wanda Maximoff', 'Street D', 'City 4');
  mysql&gt; insert into employee values ('Raven Roth', 'Street E', 'City 5');
  </code></pre>
  <p>This is the datatypes for Work Table and values inserted:</p>
  <pre><code>mysql&gt; create table works (`employee-name` char(30), `company-name` char(50), 
  `salary` decimal(20,2));
  mysql&gt; insert into works values ('John Smith', 'MyBank', '10000');
  mysql&gt; insert into works values ('Arya Stark', 'First Bank Corporation', 
  '20000');
  mysql&gt; insert into works values ('Barry Allen', 'MyBank', '17000');
  mysql&gt; insert into works values ('Wanda Maximoff', 'YourBank', '125000');
  mysql&gt; insert into works values ('Raven Roth', 'MyBank', '20000');
  </code></pre>
  <p><strong>The question I got from my lab practical is:</strong> Find the names, street address,
  and cities of residence for all employees who work for 'First Bank
  Corporation' and earn more than $10,000</p>
  <p>Every time I enter this the error comes up:</p>
  <pre><code>select employee.employee-name, employee.street, employee.city from
  employee, works
  where employee.employee-name=works.employee-name
  and company-name = 'First Bank Corporation' and salary &gt; 10000;
  ERROR 1054 (42S22): Unknown column 'employee.employee' in 'field list'
  </code></pre>