title: MYSQL: ERROR 1054 (42S22): Unknown column 'id_employee' in 'from clause'
body: <p>I have two tables. </p>
  
  <p>i) order_details :</p>
  
  <blockquote>
  <pre><code>CREATE TABLE `order_details` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `content` text,
    `id_employee` INT(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `FK_id_employee` (`id_employee`),
    CONSTRAINT `FK_id_employee` FOREIGN KEY (`id_employee`) REFERENCES `employees` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  </code></pre>
  </blockquote>
  
  <p>ii) employees   :</p>
  
  <pre><code> CREATE TABLE `employees` (   `id` INT(11) NOT NULL AUTO_INCREMENT,   `firstname` text NOT NULL,   `lastname` text NOT NULL,   `salary` FLOAT DEFAULT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ;
  </code></pre>
  
  <p>I want to get firstname, lastname and details of order that employee 3 is responsible for. I used this :</p>
  
  <pre><code>SELECT lastname, firstname, content FROM order_details INNER JOIN employees USING (id_employee) WHERE id_employee = 3;
  </code></pre>
  
  <p>but I'm getting this error message: <code>ERROR 1054 (42S22): Unknown column 'id_employee' in 'from clause'</code> and have no clue where it came from :(</p>