Re: Problem w/ Join... Using (...) Syntax

operationsengineer1@yahoo.com wrote:
> how does one apply the JOIN... USING (...) syntax when
> the primary key and foreign key have different names?
> 
> JOIN t_employee USING (employee_id)
> 
> works perfect when the primary and foreign key are
> both named employee_id.

t_inspection JOIN t_employee
ON (t_employee.employee_id = t_inspection.inspector_id)


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.