[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: John Locke <..hidden..>
- Date: Wed, 22 Jun 2011 10:12:56 -0700
On 06/21/2011 04:02 PM, Chris Travers wrote:
> 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;
>
db=> SELECT p.id as person_id, e.id as entity_id
db-> FROM person p
db-> JOIN entity e ON (e.id = p.entity_id)
db-> order by p.id;
person_id | entity_id
-----------+-----------
1 | 1
3 | 653
4 | 654
5 | 667
(4 rows)
> This should not contain any personal info but would allow me to look
> at the join issues involved,
>
> Best Wishes,
> Chris Travers
>
> ------------------------------------------------------------------------------
> EditLive Enterprise is the world's most technically advanced content
> authoring tool. Experience the power of Track Changes, Inline Image
> Editing and ensure content is compliant with Accessibility Checking.
> http://p.sf.net/sfu/ephox-dev2dev
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel