[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Employee search question for 1.3
- Subject: Re: Employee search question for 1.3
- From: Chris Travers <..hidden..>
- Date: Tue, 21 Jun 2011 16:02:29 -0700
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