求助!如何实现这样的复杂查询?SQL高手进来……
风里有梦 2005-12-09 10:01:35 查询A表,A表查询我没问题,现在问题是:
A表中有三个字段是另外三个表中的编号,我想要他们的名称,但是名称是在那三个表中。我本想通过下面这条语句实现,未料出错了……
SELECT e.name, d.name as department, c.name as company, s.name as supplier FROM employee e (INNER JOIN depart d ON d.id = e.departID, INNER JOIN comp c ON c.id = e.companyID, INNER JOIN supp s ON s.id = e.supplierID)