[EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
