SQL数据库中，假设有两个表：company(id int，name text)和 employee(id int, company int, name text)。如何选择所有员工姓名及其对应的公司名称( )
例如 :
John Microsoft
Mary IBM
Jane Oracle
select employee_name, company_name from employee and company
select e.name, c.name from employee e left join company c
这是不可能的
select e.name, c.name from employee e left join company c on c.id = e.company
select e.name, c.name from employee e, company c
