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.