[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Employee search question for 1.3



Hi John;

In terms of the duplication issue can you:

SELECT p.id as person_id, e.id as entity_id
  FROM person p
  JOIN   entity e ON (e.id = p.entity_id)
 order by p.id;

This should not contain any personal info but would allow me to look
at the join issues involved,

Best Wishes,
Chris Travers