关联查询存在sql异常

[xiaobin]

关联查询时，可以left join 表，但没有连接表之间的语句。如下：
select employee.firstname as firstname, employee.lastname as lastname, employee.email_address as email_address, employee.gender as gender, employee.constellation as constellation, employee.binary_data as binary_data, employee.last_modified_date as last_modified_date, employee.created_date as created_date, employee.last_modified_by as last_modified_by, employee.version as version, employee.created_by as created_by, employee.age as age, employee.country as country, employee.city as city, employee.street_number as street_number, employee.street_name as street_name from employee employee left outer join department employee.department on WHERE employee.firstname = ? and employee.lastname = ?