Re: Two Tables That Share Data?

On 9 February 2012 17:33, Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> wrote:
> OK I have my 'employees.dept' field type set to INTEGER but I'm still
> trying to understand how I can perform a SQL statement that will allow
> me to query the 'employees' table and visibly see employees.manager =
> 'Phill Collins' rather than it's assigned numerical INTEGER. Below are
> both tables described:

Try something like this:

SELECT e.fname AS emp_fname, e.lname AS emp_lname, m.name AS manager
FROM employees AS e
INNER JOIN managers AS m ON e.manager = m.id
WHERE e.salary = 12345.67;

--
Michael Wood <esiotrot(at)gmail(dot)com>