How to fix this error and select from multiple tables?

How to fix this error and select from multiple tables?

I have a question about listing tables and I don't understand my error. It
says to List the companyname, division, city of employers associated with
interviews scheduled for 19951.
I'm trying to list the records based on the qtrcode found in interview table.
I have this code:
SELECT companyname, division, city
FROM employer
WHERE interview.qtrcode = '%19951%';
ERROR 1054 (42S22): Unknown column 'interview.qtrcode' in 'where clause'
Table should look like this and havent got any output due to this error.
+------------------------------+------------------+------------------+
| companyname | division | city |
+------------------------------+------------------+------------------+
| Acme Information Source | Customer Support | Cleveland |
| Braddock Information Assoc. | Payroll | Boston |
| Ajax Software, Inc. | Production | Berkeley |
| Ajax Software, Inc. | RandD | Berkeley |
| Bay Software Inc. | Production | Berkeley |
| Vegas Programming and Design | Development | Las Vegas |
| Mountainside Magic Software | Management | Colorado Springs |
| Mountainside Magic Software | Customer Support | Colorado Springs |
+------------------------------+------------------+------------------+
8 rows in set (0.00 sec)