[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_em
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.
however, it one is named inspector_id and the other
employee_id, it doesn't
