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

Re: Employee search question for 1.3



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